LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 130
Default One or More Links cannot be updated Error

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable find files error message for missing links on opening WB RAZA Excel Discussion (Misc queries) 3 May 10th 06 12:32 PM
multiple links creation error Devin D Excel Discussion (Misc queries) 0 April 20th 06 04:22 AM
How to obtain both std dev and std error mean in each y error bar Augabog Excel Worksheet Functions 2 April 16th 06 06:41 PM
Error Handler Not Working Bill Excel Discussion (Misc queries) 0 August 25th 05 07:13 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"