Excel to PowerPoint Link

[Totteridge Ram]

Hi all - will try my best to explain my issue & hope someone can help me.

I have an Excel workbook (WB1) and I have a Powerpoint presentation (PP1).
Content in PP1 is "paste special linked" to some tables I have created in
WB1. Both files are stored in folder Month1.

Now along comes Month2 and I want to drop in new data into WB1 and do a
"file save as" to WB2. I do the same with Powerpoint so end up with PP2 &
WB2 in a folder called Month2.

But I now want PP2 to be linked to the content in WB2, but of course it is
still linked to WB1. Each month I go through and delete everything and
replace with new links. This takes ages as I have so many links and it ends
up being very, very, very messy.

There must be a better / easier way. Can anyone help?

 

[Steve Rindsberg]

Hi all - will try my best to explain my issue & hope someone can help me.

I have an Excel workbook (WB1) and I have a Powerpoint presentation (PP1).
Content in PP1 is "paste special linked" to some tables I have created in
WB1. Both files are stored in folder Month1.

Now along comes Month2 and I want to drop in new data into WB1 and do a
"file save as" to WB2. I do the same with Powerpoint so end up with PP2 &
WB2 in a folder called Month2.

But I now want PP2 to be linked to the content in WB2, but of course it is
still linked to WB1. Each month I go through and delete everything and
replace with new links. This takes ages as I have so many links and it ends
up being very, very, very messy.

There must be a better / easier way. Can anyone help?

Two approaches:

1) Use a little VBA code to search/replace on your links:

Search and Replace for Hyperlinks, OLE links, movie links and sound links
http://www.pptfaq.com/FAQ00773.htm

Use that to change all "Month1" references to "Month2"

2) Mess with its head

Generally PPT will search for/find OLE linked files (like yours) first along
the path where the file's supposed to be (ie, in Month1) and if it doesn't
find the file there, it'll look in the same folder as the PPT itself, so long
as you opened the PPT in any way OTHER than using the Most Recently Used list.

SO

If you make the original file unavailable but put the edited copy of it in the
same folder as the PPT, it should update to the latest numbers.

You may actually have to delete the original or move it to offline storage;
some Win versions have a service that tracks linked files and helps apps find
even moved files. This is the last thing you need, given what you're trying
to do.