Erroneous link update message on open

QuakerDude said:

I have 2 workbooks with the same problem. Both files and the linked file are on a mapped networked drive. I am using Excel 2003 SP3.<o></o>
<o> </o>
Message reads: This workbook contains one or more links that cannot be updated and the choices are to either update the links or continue.<o></o>
<o> </o>
The problem is that when I click edit links, the edit links DB box opens with the link status as OK…and if I click to continue on opening all is well…either way the links work but I can not stop the message from appearing.<o></o>
<o> </o>
BTW: I have others in the office using this same link formula and no one else gets this message.<o></o>
<o> </o>
I have selected “Startup Prompt…” from the edit links DB box and selected “Don’t display the alert and update links” and I have Tools-Options-Edit-“Ask to update links” unchecked.<o></o>
<o> </o>
The link is:<o></o>
=IF(B444="","No UserID",VLOOKUP(B444,'I:\xxx\xxx\[workbook name.xls]Sheet1'!$A$1:$A$45000,1))<o></o>
<o> </o>
As you can see, the formula looks to a particular cell (in this case B444) and if the cell is blank enters No UserID in the cell. If there is a UserID in the cell it attempts to find it.<o></o>
<o> </o>
This is the only link in the book and if I edit the link the status is always OK.<o></o>
<o> </o>
This one has me stumped!<o></o>

Click to expand...

Sorry that my post will not help you out. I'm actually in the exact same boat. Have you found a solution to your problem?

I'm at the point where I'll probably have to rebuild the sheet. The worksheet that is causing me issue works perfect in the other workbooks I have, but for some reason always shows as an error in this case. The status meanwhile shows OK and I can even open the source document correctly.

In the past when I've encountered the problem, it was due to some bad named ranges (REF errors). You might check those in Insert--Name and see if anything is floating around. However that solution has not worked for me in this case.

Yes I have....some one from another forum site sent me this reply:

Check for any defined names with #REF in the Refers To: box. This can cause the error you're referring to.

My response back was:

I would have never found that problem.

In these particular workbooks I was not using any defined names but when I checked, one book had one name and the other had 2. All 3 were pointing to old books that had been archived. The names did not show any errors but when I deleted them the problem was resolved.

Again, thanks for the fix!

Hope this helps you too!

Thanks guys! Mr. Excel rocks!

I've been struggling with this exact same error scenerio for a couple weeks now.

Derek

It looks like quite a few people had this issue...glad it helped.

Thanks to you, QuakerDude, to whoever sent you the first solution, and to all involved. This issue has been distracting me for over a month, and it seems to now finally be resolved!

I might add that in fixing the problem in my case I was misled by the "Define Name" dialog box in Excel 2003, in which the top portion says "Names in workbook". This implies that all defined names in the workbook are displayed by this box regardless of which worksheet the user is on. After some frustration, I found out that there were defined names on several of the worksheets in the workbook I was using that did not show up in this box unless the "Define Name" dialog box was pulled up separately on each of them.


Opinions expressed are the sender's and are not necessarily the opinion of the County of San Diego.

Hey all. Just had to let you know that I just registered to Mr. Excel so I could say thanks for this post. I NEVER would have worked this out and you have all definately saved me many hours of pain. Thank you, thank you, thank you!!!!!


Iatollah

Guys

I created this profile just to be able to thank you!

shiva

Lest all think this hint works all the time... I have the same problem. There are no links in the Name Manager that refer to an external link. I have 12 worksheets in the one workbook and the link is referring to an old version of the workbook. Any other ideas would be greatly appreciated.

Thanks,

George