Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a client that has a PowerPoint Presentation, with charts and linked
workbooks. The excel workbooks in turn have formulas referring to other workbooks. When you open the PowerPoint presentation, you need to update the links to get the most up to date information. What is happening when the links are updated, is: It opens the Excel File It asks if you want to update the Excel links to other workbooks If you choose no, the same message box opens in an infinite loop If you choose yes or update, it clocks and then says one or more links cannot be updated, and then asks whether you want to continue or edit links. Continue loops back to same questions Edit links brings up links dialog box, but when you edit them, they loop again Reviewing the Excel file, I have deleted the named ranges linked to files in temp folders, and those with REF in the links. I also checked the charts, and made sure they were referring to ranges internal to the workbook. THe problem still occurs. Any ideas what is causing this to loop? Any ideas as to a solution? Thanks in advance for ANY help you can provide. He is using Office 2003. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable find files error message for missing links on opening WB | Excel Discussion (Misc queries) | |||
multiple links creation error | Excel Discussion (Misc queries) | |||
How to obtain both std dev and std error mean in each y error bar | Excel Worksheet Functions | |||
Error Handler Not Working | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |