Workbook contains one or more links that cannot be updated

[shiguera]

Hi all,

I have Excel 2003. I'm getting this message when I run a macro that reads values from n (variable number of files) number of files. If I choose Continue, the macro runs ok but at the end, I check the Edit-Links window and always the last file comes up with "unknown" status; I check the status and it goes to OK.

Now, the real problem, I believe, is seen when I run the macro and choose Edit Links instead of Continue. At this point I see that a file shows up in the list, which does not exist anymore (or was renamed) but there is nothing actually linking to it in my wb. I've read these two threads below and done what they suggest and can't find anything. However, tried looking for the #REF defined names, but I want to make sure the procedure is right: Insert-Name-Define and in the box for Refers to: #REF clik Enter and the window closes without any message; does that mean there are no #REF's?


http://www.mrexcel.com/forum/showthread.php?p=1538394
http://www.mrexcel.com/forum/showthread.php?t=308563

Any help would be appreciated.

 

[shiguera]

I downloaded the FindLink and NameManager from:

http://www.oaltd.co.uk/MVP/Default.htm

and neither of them found anything.

 

[xenou]

When you are in the names dialog box, the bad names show up like this (excel 2003):

<img src="http://i617.photobucket.com/albums/tt259/alex44141/MrExcel/20090214_Names.jpg" border="0" alt="names dialog box">

You need to actually delete the name altogether when the name is bad...in this case hit the delete key after selecting the name in the window. I found I had maybe one or two workbooks where even after this there was still a problem...though I haven't seen that message for a while now.

Does that help? Alex

 

[shiguera]

thanks,

yes, it is clear but in my case the list is empty.

 

[xenou]

Sometimes there are links that are due to bad references in the vbe too...not sure...If you go to Tools | References in the VBE is anything "MISSING"?

I had this happen to me about two years ago too...never could find the source of the problem...

It may help if you have your code open the file before getting to the statements that refer to the file. Excel seems to handle links faster and better when the external workbooks are already open.


-------------------------------------------------
Another idea might be to "Break Link" on that file...does that help? Probably you've tried that already...

 

[shiguera]

Hi Alexander,

thanks for the reply. There is nothing Missing and about the second option, when I see the file under the Edit-Links window, the button to break the link is grayed out, so I can't do that either.

I think I will have to recreate teh sheet to solve the problem.... thanks for the help anyway.

 

[xenou]

Yes, sounds like something that would be hard to weed out otherwise. Rebuilding is always an option:
http://www.mrexcel.com/forum/showthread.php?t=223851

I've had cases where I've assigned a macro to a button or shape and the macro I assigned was in a different workbook...which got lost...