Creating Powerpoint doc that will automatically update from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb Reinhardt - 26 Sep 2006 19:03 GMT

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

Reply to this Message

tohlz - 26 Sep 2006 19:11 GMT

Check this out:
"Linking information from Excel"
http://www.rdpslides.com/pptfaq/FAQ00593.htm

Signature

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

> 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
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Barb Reinhardt - 26 Sep 2006 19:20 GMT

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.

> Check this out:
> "Linking information from Excel"
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message

tohlz - 26 Sep 2006 19:33 GMT

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.

Signature

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

> 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
[quoted text clipped - 14 lines]
> > >
> > > Thanks

Reply to this Message

Barb Reinhardt - 26 Sep 2006 19:27 GMT

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.

> Check this out:
> "Linking information from Excel"
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message

Steve Rindsberg - 27 Sep 2006 05:11 GMT

> 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.

Reply to this Message