Hi, I have created some charts and tables in Excel and would like to automatically have them linked in a ppt file. So I copied the charts and tables and did paste special and paste link in ppt. However, I am unable to change the link source in ppt to a different Excel file by clicking on the Office button - Prepare - Edit Links to File - Change Source and choose the new Excel file.
For example I have a file named File Jan.xlsm already linked to the ppt. Then I tried to redirect the link to File Feb.xlsm. The error message is "The link file is not unavailable..."
Below are the linked path. I can see the second half was not updated.
Original path - C:\Test\Feb Jan.xlsm!OPEX![File Jan.xlsm]Sheet1 Chart 1
New path - C:\Test\File Feb.xlsm!OPEX![File Jan.xlsm]Sheet1 Chart 1
Can someone help? Thanks.