PC Review

Thread Tools Rate Thread

Update links box gives Continue or Edit Links dialog

Posts: n/a
      18th May 2007

I have one main spreadsheet. To this spreadsheet are linked 3 other files
via vlookup formlae where the named range referred to in the formulae is
linked to a non-dynamic range in the main spreadsheet. The ranges are
identically defined in each spreadsheet. Two of the linked files have no
problem when Update Links is chosen upon file open. The third file, however,
always returns the "one or more of your links could not be updated" box where
you have to choose to Continue or Edit Links. If I choose Edit Links, it
tells me that the status is OK. If I choose Continue, and then edit my links
to refresh the data, the status changes from Unknown to OK.

I can't think of any reason why this third file does not automatically
accept the link.

Does anyone have any ideas? I'm using the Name Manager Add-In to check all
of my ranges and they are identical.

Thanks very much.

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Suppress Update Links dialog AND don't update links Paul Martin Microsoft Excel Programming 5 3rd Aug 2006 01:14 AM
Annoying dialog box "Press OK to continue loading the content of this page" Antonio Windows XP Internet Explorer 1 29th Mar 2004 10:50 PM
Persistent dialog box "Press OK to continue loading the content of this page" Antonio Caldas Windows XP Internet Explorer 1 12th Dec 2003 01:54 PM
Missing Edit|Links Dialog Box jason Microsoft Excel Misc 2 27th Sep 2003 04:15 AM
E-Mail Updates Continue and Continue, Why??? DaveA. Windows XP Security 1 20th Sep 2003 08:02 PM




All times are GMT +1. The time now is 04:21 AM.