Forum Discussion
SubhasisB
Sep 15, 2020Copper Contributor
Linking PowerPoint with excel
Hi, I have PowerPoint presentation with lots of tables and charts and is linked with a excel file, every month I need to create a copy of the excel and PPT and rename them like June, July, Aug. So in ...
mathetes
Sep 16, 2020Gold Contributor
Is the PowerPoint file a template, so that it's always blank when you first open it, waiting for the link to be filled? If so, I should think you could name the Excel file "CurrentData" or some equivalent, only applying the month's name when it's no longer current?
It's hard to visualize the exact circumstances that you're dealing with, but it sounds like something that could be resolved just by re-thinking the naming convention being used. So tell me what I'm missing.