I have been given the job to update a powerpoint which has about 100 charts in it that link to a single (very large) excel spreadsheet.
At present these links refer to an old version of the excel file in a specific file locations. The only way I can get the update link function to work is to rename the latest version of the excel spreadsheet as its old name and put in the old file location before I open the powerpoint.
As all the charts update from the same excel spreadsheet I would like to be able to update the file name and location for all the links at the same time. Ideally having a window come up that prompts the users to point to the excel file from which the powerpoint should update everytime. Is this possible with VBA?
It would save me a huge amount of time if I could! You help is appreciated.