replace all excel links on powerpoint at once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a powerpoint file, which has 20 links to the different tables and
charts on the same excel file's different tabs.

I do this report every month. The new data for each month is saved on a
new excel file in a differetn folder with the same format. => different file
path.

Is it possible to change the source (excel link file path) on my powerpoint
file at once in stead of doing it one by one?

thanks
 
hi, prettybady,
I have no idea how to update all the links at once. But I suggest maybe
you can use a fixed excel file in a fixed folder under this
circumstances. I mean you can name the Excel file and latest.xls and
the folder as latest. So every time you can put your latest data into
the latest.xls and since there is no change needed in your powerpoint
file, you can save some efforts then.

Hope this can help.
Best regards,
KPP
 
If you check out the archives on Google groups, you will find several VBA
examples posted by me to change links. You can also try out the links
manager tool in the free evaluation copy of Toolbox for PowerPoint.
 
Where is the Google groups?

Shyam Pillai said:
If you check out the archives on Google groups, you will find several VBA
examples posted by me to change links. You can also try out the links
manager tool in the free evaluation copy of Toolbox for PowerPoint.

--
Regards,
Shyam Pillai

Toolbox: http://skp.mvps.org/toolbox
Click to expand...
 
:

I need to change the excel file name. everything else stay the same. how
do i do that w/o breaking the links.

link manager seems can only change the folder not the excel file name.

please help.. thanks
 
prettybaby,
with no intention of insulting you, IMO you are going about this
linking in a way that is going to make your life awful fairly soon. If
I were to do this, I'd have a current data file.xls which is where
everything is linked from. Then when I wanted new data, I'd rename the
currrent data file.xls to something descriptive like January 2005
Sales.xls And then repopulate teh current data file.xls with the next
month's data.

Actually, I wouldn't do linking at all but use VBA to copy and paste
named ranges or charts into PPT. Much safer and not fragile like
linking is.

Brian Reilly, MVP
 
i realized that. oh what is VBA?

Brian Reilly said:
prettybaby,
with no intention of insulting you, IMO you are going about this
linking in a way that is going to make your life awful fairly soon. If
I were to do this, I'd have a current data file.xls which is where
everything is linked from. Then when I wanted new data, I'd rename the
currrent data file.xls to something descriptive like January 2005
Sales.xls And then repopulate teh current data file.xls with the next
month's data.

Actually, I wouldn't do linking at all but use VBA to copy and paste
named ranges or charts into PPT. Much safer and not fragile like
linking is.

Brian Reilly, MVP
Click to expand...
 
Back
Top