+ Reply to Thread
Results 1 to 3 of 3

Workbook contains links that cannot be updated

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Silicon Valley, California
    MS-Off Ver
    2007
    Posts
    40

    Workbook contains links that cannot be updated

    When I opened a workbook that I hadn't used in awhile, I got a pop-up error message saying, "This workbook contains one or more links that cannot be updated". I've attached a screen shot of that pop-up and the ones that followed.

    I clicked on the Edit Links button and was shown the Edit Links dialog. It listed one entry, my add-in module, with an Update setting of "A" (automatic?) and a Status setting of "Unknown" (what does that mean?). Pretty cryptic so far.

    Someone in another thread said to open the Name Manager, so I did. I found 6 entries with "#REF" in the Value column. In the Refers To column, they all had a path to a workbook that doesn't exist. I opened the sheet in the Scope column and searched for the Names that had a value of "#REF". None of them were referenced on that sheet or any sheet in that workbook.

    My main question is what to do with them? It seems like I can just delete them, since they don't exist and aren't referenced.

    My second question is how did this happen?

    Thanks

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Workbook contains links that cannot be updated

    delete them,
    as to why
    reading this on link management my give some ide
    http://office.microsoft.com/en-gb/ex...ther_workbooks
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    09-22-2014
    Location
    Silicon Valley, California
    MS-Off Ver
    2007
    Posts
    40

    Re: Workbook contains links that cannot be updated

    OK, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-21-2013, 10:06 AM
  2. Replies: 3
    Last Post: 11-06-2012, 07:27 AM
  3. Error: 'Workbook contains one or more links that can not be updated'
    By Douglas Inc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-20-2012, 09:56 AM
  4. One or more links in this workbook cannot be updated
    By jacob@thepenpoint in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-23-2011, 05:00 PM
  5. prevent error on workbook open (links could not be updated)
    By neowok in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2005, 11:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1