Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links between Excel & PowerPoint
I have a fairly large PowerPoint file, approx. 100 slides that are linked to
6 different Excel workbooks. The workbooks are updated monthly, renamed and then I open the PowerPoint file and update the links via EditLinks, and then save the file. When I reopen the PowerPoint file the next day, the links have reverted back to the old Excel workbooks. I then go through all the relinking and it works fine. This happens every month and I don't know why or how to fix this. Any help would be appreciated. Thanks. -- Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links between Excel & PowerPoint
I would archive the old month's files, and keep using the same workbook name
each month for the updated workbooks. No need to mess with Edit Links. I don't do a lot of linking. Instead I use routines that put pictures of the charts into the slides, usually using a table with relevant information (i.e., source workbook and worksheet, chart name, target slide, chart position and size). This gives me a robust, lightweight snapshot in each PowerPoint file. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chris" wrote in message ... I have a fairly large PowerPoint file, approx. 100 slides that are linked to 6 different Excel workbooks. The workbooks are updated monthly, renamed and then I open the PowerPoint file and update the links via EditLinks, and then save the file. When I reopen the PowerPoint file the next day, the links have reverted back to the old Excel workbooks. I then go through all the relinking and it works fine. This happens every month and I don't know why or how to fix this. Any help would be appreciated. Thanks. -- Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
links to a powerpoint file in excel | Excel Discussion (Misc queries) | |||
Links between Excel, and Excel within PowerPoint | Excel Worksheet Functions | |||
Excel - PowerPoint links | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
EXCEL AND POWERPOINT | New Users to Excel |