+ Reply to Thread
Results 1 to 15 of 15

Edit Links problem - "...links cannot be updated..." error always occurs

  1. #1
    Registered User
    Join Date
    06-08-2007
    Posts
    22

    Edit Links problem - "...links cannot be updated..." error always occurs

    I have a spreadsheet which pulls data from two other spreadsheets. Every time I open this, I get the "This workbook contains one or more links that cannot be updated error."

    Very annoying.

    Updating skips past this and all works fine. Choosing edit links shows me that both links have an "OK" status, that the updates are automatic, and I have the startup prompt set to "Don't display the alert and update links".

    So why does this keep popping up, and how can I get this to cease?

    Thanks!

  2. #2
    Registered User
    Join Date
    06-08-2007
    Posts
    22

    Nevermind, figured it out.

    For others having the same issue, here's what I found.


    Though the edit links correctly showed the two worksheets being referenced correctly, and had the auto-update correctly set without asking for a prompt, there were some defined names that weren't valid not addressed by the EDIT LINKS control.

    'Cntrl' + 'F3' brings up the defined names in the worksheet. I found several names here referencing worksheets that don't exist (I adapted my worksheet from a pre-existing worksheet). Deleting these solved my problem.

  3. #3
    Registered User
    Join Date
    02-04-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    1

    Thumbs up Re: Edit Links problem - "...links cannot be updated..." error always occurs

    WORKS LIKE A CHARM !!! IF you want the answer to a possible prolbem. The answer above was perfert form me. This file was copied from a server, and I couldn't believe the garbage on it. The keyboard shortcut showed me all.....and I was able to delete them all. This answer was so profound, I even saved it for future knowledge. Thank you !!!

  4. #4
    Registered User
    Join Date
    12-30-2013
    Location
    St Austell, Cornwall
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    Worked for me too! Thank you, been driving me insane for weeks!

  5. #5
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    I found another issue recently and discovered this linke which I thought was very helpful in finding that irritating hidden broken link:
    http://office.microsoft.com/en-us/ex...010205611.aspx
    http://www.extendoffice.com/document...all-links.html
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

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

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    This problem just happened to me. Stir-crazy's Ctrl+F3 produced the Name Manager (also accessible from the Formulas tab). There I found 6 names in one sheet with the #REF value. But when I go to that sheet and search for those names, I am told that they do not exist.

    What's the deal? Do these names exist and are undefined or do they not exist?

    More importantly, can I just delete them?
    Attached Images Attached Images

  7. #7
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,312

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    Hi Cynthia,

    We would love to help you with your query, but first, before we can proceed, please see our Forum Rules and adjust accordingly...

    2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.
    HTH
    Regards, Jeff

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

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    Quote Originally Posted by jeffreybrown View Post
    Hi Cynthia,

    We would love to help you with your query, but first, before we can proceed, please see our Forum Rules and adjust accordingly...
    Hmmm... This "rule" seems arbitrary and counter-productive to me. I thought this was a discussion group, not a private exchange between one person and the respondents. I had the exact same problem as the OP. I added information that contributed to the thread. How is it more efficient or more useful to start a parallel thread and go through the bother (both for me and for future readers) or connecting the two?

    Secondly, did this rule come into existence since January? The OP posted in Dec 2007 and answered his own question. In Feb 2012, another person added a comment. Again in January, still another person chimed in. None of them got scolded. Now I add the next step in the solution of the problem and you tell me to start all over in a separate thread.

    Does this really make sense to you?

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,871

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    Cynthia, this rule has been in existance for years, and many other forums have a similar rule. The comments you mentioned where assisting to add more suggestions for solving the question, not adding their own

    Also, far from being counter-productive, the rule there to try and help members get answers - old post like this 1 (this particular 1 is 7 years old), seldom get revisited by members looking to answer questions, it just so happened that this thread got a few additional answers, but that is the exception rather than the norm.

    Look at it this way, even if this was a brand new post, and, say, 3 other members started posting their own (related) questions on here, you can imagine for yourself how chaotic the thread could become...various members posting answers to different questions, all on the same thread...and this would become even worse if the question was a complex one To this end, we try to keep things as simple as we can - 1 thread poster, 1 thread

    I hope this makes more sense to you now?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

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

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    there goes the santa hat ,ford
    "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

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,871

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    lol I actualy an wearing 1 right now - that says Bah Humbug

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

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    Quote Originally Posted by FDibbins View Post
    Cynthia, this rule has been in existance for years, and many other forums have a similar rule. The comments you mentioned where assisting to add more suggestions for solving the question, not adding their own

    Also, far from being counter-productive, the rule there to try and help members get answers - old post like this 1 (this particular 1 is 7 years old), seldom get revisited by members looking to answer questions, it just so happened that this thread got a few additional answers, but that is the exception rather than the norm.

    Look at it this way, even if this was a brand new post, and, say, 3 other members started posting their own (related) questions on here, you can imagine for yourself how chaotic the thread could become...various members posting answers to different questions, all on the same thread...and this would become even worse if the question was a complex one To this end, we try to keep things as simple as we can - 1 thread poster, 1 thread

    I hope this makes more sense to you now?
    I understand the rule and I think I understand the rationale. I just don't agree with it. It's too rigid. A better rule would be not to post off-topic messages or derail the thread from the original question. In my opinion, my post added significantly to the discussion. It did not detract or complicate it.

    I follow dozens of forums and I have never run into anything as rigid as this.

    But it's your forum, so you can run it however you like.

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

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    Posts 31
    v
    Posts 23,927
    hmm you just have to take it on the chin. no point arguing about the rules, we have all tried at some point, and valuable members have left

  14. #14
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,871

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    Cynthia, I hear your concern and value your input, but if we changed the rules to suite every member's taste and preference, then that's all we would end up doing - changing (and re-changing) rules all the time. (you know what they say - you can please some of the people, some of the time....)

    While we do fine-tune our rules as needed, the basic concepts have worked well for us, and will probably continue to do so until something significant happens. Each forum has its own set of rules, and it's own standards regarding how those rules need to be abided by...some are very laid-back, others are far more strict than we are, it is up to each individual to find the balance between getting the help they want, and a forum with norms that are to their taste.

    I believe that we are 1 of the biggest forums for what we have to offer, and as such, it would seem that the vast majority of members are OK with our rule set - or at least, are willing to abide by them in order to get what they want from us.

    I sincerely hope this is acceptable to you now, and that you stick around with us to learn and contribute

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

    Re: Edit Links problem - "...links cannot be updated..." error always occurs

    Please do not change the rules to please me. If you don't find my argument persuasive so be it. In my opinion, you are missing out on some lively discussions, but it's your call.

    As an aside, popularity is no guarantee of quality. There might even be a negative correlation. I've read that Fox News is the most watched cable news network. Now that's a persuasive argument. And they really should put "news" in quotes.

    Peace

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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