Creating Powerpoint doc that will automatically update from Excel

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Steve Rindsberg]

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.

Something like this:

Show me the link and let me edit it
http://www.pptfaq.com/FAQ00433.htm

Alternatively, you could create your 2005 file and save a copy as MASTER.XLS (or
whatever name you want to give it ... doesn't really matter). Create the links from
MASTER.XLS.

When you want to replace your 2005 data with 2006 data, edit the 2005 file, save it
as 2006, then also save a copy as MASTER.XLS, overwriting the old version of the
same name.

PPT will continue to link to MASTER.XLS, but will now have the new data.