Creating Powerpoint doc that will automatically update from Excel

[Barb Reinhardt]

We have an excel document (with multiple worksheets and charts) that needs to
be used within a PowerPoint presentation. Many of the worksheets need to be
displayed on a page within the presentation. If the worksheets update, the
presentation needs to update.

Can someone direct me to information on how to set up such a file?

Thanks

 

[tohlz]

Check this out:
"Linking information from Excel"
http://www.rdpslides.com/pptfaq/FAQ00593.htm
--
Shawn Toh (tohlz)
Microsoft Most Valuable Professional (MVP PowerPoint)

Site Updated: Sep 01, 2006
3 Cool Add-Ins Reviews
http://pptheaven.mvps.org
PowerPoint Heaven - The Power to Animate

 

[Barb Reinhardt]

I can envision that the users would want to have an updated version of the
Excel file "Measures 2006-09" and "Measures 2006-10" and would also want to
have an updated file name for the PowerPoint document. Any suggestions on
how that could be achieved. I didn't see anything obvious in the link you
listed.

 

[Barb Reinhardt]

I've played around with the EDIT LINKS and attempted to record a macro to see
what was happening, but nothing was recorderd. I'm thinking this will need
to be done with VBA.

 

[tohlz]

Create a folder first, move both the Excel and PowerPoint files into the
folder.
Open the Excel file, copy the cells that you want to show in PowerPoint.
Open the PowerPoint file, click Edit > Paste Special.
Select Paste Link.
Save the PowerPoint file.
If you update the content in Excel, you will be prompted to update link in
PowerPoint.
You can change the file name for PowerPoint or have an updated version, but
you can't save the Excel file under a new file name though as it is pointing
to a specific link.
See if others have a solution for this.
--
Shawn Toh (tohlz)
Microsoft Most Valuable Professional (MVP PowerPoint)

Site Updated: Sep 01, 2006
3 Cool Add-Ins Reviews
http://pptheaven.mvps.org
PowerPoint Heaven - The Power to Animate