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!
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.
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 !!!
Worked for me too! Thank you, been driving me insane for weeks!
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.
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?
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
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?Originally Posted by jeffreybrown
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?
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 oneTo 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
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
lol I actualy an wearing 1 right now - that says Bah Humbug
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.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
I hope this makes more sense to you now?
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.
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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks