Multiple Excel Worksheets in Powerpoint

[Guest]

I have training material which I have an excel worksheet on a slide. I
update the data for each class I teach. I then use the same data in two
later slides with different worksheets that need the same data. Is there
anyway to update the two later worksheets on the two later slides
automatically with the data from the first slide.(ie how do I link multiple
worksheets in powerpoint to each other.) I need to do this all in one file
and not have multiple files to reference.

Thanks for any guidence.

 

[Steve Rindsberg]

I have training material which I have an excel worksheet on a slide. I
update the data for each class I teach. I then use the same data in two
later slides with different worksheets that need the same data. Is there
anyway to update the two later worksheets on the two later slides
automatically with the data from the first slide.(ie how do I link multiple
worksheets in powerpoint to each other.) I need to do this all in one file
and not have multiple files to reference.

Here's something I just posted earlier today:

If you link information from Excel into PPT, then you can doubleclick to edit
it from within PPT. Changes to the linked information are actually changes to
the original Excel file. And if you edit the Excel file, PowerPoint will offer
to update presentation the next time you open it.

Linking information from Excel
http://www.rdpslides.com/pptfaq/FAQ00593.htm

You should be able to extend this a wee bit and make it work the way you'd like
it to. Let's say you have data on Worksheet1. You copy and paste link the
bits you want into Worksheet2.

Paste/Link from both worksheets into PPT slides as described in the link above.

You could then doubleclick the linked content from Worksheet1 in PPT, edit it
and click back. You might have to force a manual update of the other links but
they'd reflect the changes, I think.

You'd want to be careful about editing the data linked from the other
worksheets though. By changing it, you might inadvertently break the links
from worksheet to worksheet.