Linking PowerPoint with excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1670376%22%20slang%3D%22en-US%22%3ELinking%20PowerPoint%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1670376%22%20slang%3D%22en-US%22%3EHi%2C%20I%20have%20PowerPoint%20presentation%20with%20lots%20of%20tables%20and%20charts%20and%20is%20linked%20with%20a%20excel%20file%2C%20every%20month%20I%20need%20to%20create%20a%20copy%20of%20the%20excel%20and%20PPT%20and%20rename%20them%20like%20June%2C%20July%2C%20Aug.%20So%20in%20the%20current%20month%20when%20I%20used%20to%20update%20the%20link%20it%20refers%20to%20the%20last%20month%2C%20so%20is%20there%20any%20way%20available%20to%20update%20the%20PPT%20with%20current%20month%20excel%20file%20in%20one%20go%20keeping%20the%20same%20format.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1670376%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1673152%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20PowerPoint%20with%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1673152%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767899%22%20target%3D%22_blank%22%3E%40SubhasisB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20the%20PowerPoint%20file%20a%20template%2C%20so%20that%20it's%20always%20blank%20when%20you%20first%20open%20it%2C%20waiting%20for%20the%20link%20to%20be%20filled%3F%20If%20so%2C%20I%20should%20think%20you%20could%20name%20the%20Excel%20file%20%22CurrentData%22%20or%20some%20equivalent%2C%20only%20applying%20the%20month's%20name%20when%20it's%20no%20longer%20current%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20hard%20to%20visualize%20the%20exact%20circumstances%20that%20you're%20dealing%20with%2C%20but%20it%20sounds%20like%20something%20that%20could%20be%20resolved%20just%20by%20re-thinking%20the%20naming%20convention%20being%20used.%20So%20tell%20me%20what%20I'm%20missing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
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 the current month when I used to update the link it refers to the last month, so is there any way available to update the PPT with current month excel file in one go keeping the same format.
1 Reply

@SubhasisB 

 

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.