Sep 15 2020 11:39 AM - edited Sep 15 2020 11:40 AM
Sep 16 2020 05:56 AM
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.