Update Links Error

[Guest]

I have a spreadsheet that is linked to several other Excel files. Everytime
I open the file it tells me that some of the links could not be updated and
asks to either click continue or Edit Links.

When I go into Edit Links the status for all files is OK. I have even gone
in and updated the source on them, just in the case teh status is showing
wrong. But I still get the dialog box.

Does anyone know why this might be happening or how I can pin point the
problem, that Excel is obviously not showing me.

Any help would be much appreciated!

 

[Paul W.]

http://www.oaltd.co.uk/mvp/

In the Bill Manville section
FindLinks.zip

It's an add-in for Excel.
Worked fine for me.

Paul

 

[Guest]

I had the same problem occuring in my workbook. I did the FindLinks thing
with the AddIns and it did locate exactly where the link disruption was
occuring. I have thousands of links in my workbook and I was not finding
this one errant link. Hope it works for you.