Hundreds of threads regarding powerpoint-excel linking out here, but nowhere have I seen the answer to my question.
I am creating presentations in Powerpoint with charts from a standardized excel file. The charts are linked. Each excel file contains data from one company.
But when I receive a NEW excel file/company, I would like to simply copy my powerpoint presentation template and update the links to this new excel file. Since there are maybe 50 charts linked I do not want to update each link separately.
Does anyone have a clue?
Oh, and I use simple copy-paste to create the presentation today - no vba programs.
I am creating presentations in Powerpoint with charts from a standardized excel file. The charts are linked. Each excel file contains data from one company.
But when I receive a NEW excel file/company, I would like to simply copy my powerpoint presentation template and update the links to this new excel file. Since there are maybe 50 charts linked I do not want to update each link separately.
Does anyone have a clue?
Oh, and I use simple copy-paste to create the presentation today - no vba programs.