I need to create a workbook in Excel with graphs and then copy to PowerPoint with the links in tact. This enables any changes that occur on the excel workbook to be mirrored in PP. [i.e. Each graph with show 13 months data, Jan 14 - Jan 15]
Workbook and PP are saved as say Jan Data 15.xlsx and Jan Data 15.pptx
I need to create new workbooks each month and would like to use the original as a kind of template, meaning each and every graph will be used each month but with new data to reflect that months data. [So in Mar we will add data for Feb etc]
ok here is the problem, if I save the original Excel and PP with new names Feb Data 15.xlsx and Feb Data 15.pptx the links to the Jan files get broken.
Is there a way to make the links remain with the original files and when creating the new months files to have their own links.
I hope this is self explanatory