Update links box gives Continue or Edit Links dialog

Discussion in 'Microsoft Excel Misc' started by Guest, May 18, 2007.

  1. Guest

    Guest Guest

    Hi,

    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.

    Karen.
     
    Guest, May 18, 2007
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jason

    Missing Edit|Links Dialog Box

    jason, Sep 26, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    166
    Dave Peterson
    Sep 27, 2003
  2. Guest

    Disabling Update Links dialog box

    Guest, Jul 27, 2007, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    157
    Guest
    Jul 27, 2007
  3. Guest

    Repost: Disabling Update Links dialog box

    Guest, Jul 30, 2007, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    562
    Jim Cone
    Jul 30, 2007
  4. Tasha

    Problem with Update Link prompt to Continue

    Tasha, Jan 30, 2008, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    188
    Tasha
    Jan 30, 2008
  5. Howard

    Edit Link Dialog Box

    Howard, Oct 15, 2009, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    148
    Roger Govier
    Oct 15, 2009
Loading...

Share This Page