Excel worksheet ---> PPT (V. 2003) paste link feature

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone point me to some articles, tutorial etc. for the captioned
subject please?

In PPT **normal view**, as soon as I click on the excel object/table, I am
brought to the original excel worksheet and I can edit the numbers etc.

Is it true that in **slide show view** there is no way to manipulate the
numbers?

I am thinking of demonstrating some scenarios suggested by the attendees of
a meeting during a slide show. Am I asking for the impossible? Someone told
me I could do it with three slides. No idea what he was taking about.

I guess I can do ctrl+T during the slide show and switch to Excel and do the
demonstration under Excel.

Appreciate advice.
 
Can someone point me to some articles, tutorial etc. for the captioned
subject please?

In PPT **normal view**, as soon as I click on the excel object/table, I am
brought to the original excel worksheet and I can edit the numbers etc.

Is it true that in **slide show view** there is no way to manipulate the
numbers?
Click to expand...

You can't do it the same way as you do in normal view, certainly.

But you could try including an action setting that hyperlinks to the file that
you've linked to on the slide. Click it to open the linked file, make your
edits.

But if I recall correctly PPT won't update the slide with the edited information
until you update the link manually (which you can only do via macros or in
normal view). So I guess the answer is "there's no way". At least not w/o
third party tools.
 
Steve,

I may have an alternative and I hope it is not wishful thinking this time.

When the worksheet is displayed on screen (slide show mode), I can do
alt+tab to go back to normal view. Then I just click on the object. This
should bring me to the original Excel worksheet. I can manipulate the
numbers there. I even have a choice not to save the edited numbers.

What do you think? Any drawbacks?

Epinn
 
Steve,

I may have an alternative and I hope it is not wishful thinking this time.

When the worksheet is displayed on screen (slide show mode), I can do
alt+tab to go back to normal view. Then I just click on the object. This
should bring me to the original Excel worksheet. I can manipulate the
numbers there. I even have a choice not to save the edited numbers.

What do you think? Any drawbacks?
Click to expand...

None that I can think of, as long as it feels comfortable to you.
 
Back
Top