edit links

[Guest]

I have opened a workbook"A" and received a message: "workbook contains 1 or
more links that cannot be updated". I have clicked on the "edit links" button
that gives me options : update values, change source, open source, break
link, check status. What I am trying to do is locate the cell in workbook "A"
that is linked to one of the other workbooks that is causing the problem. Can
I locate the actual cell where the link is located? This is a large
spreadsheet and I can't seem to locate any links to the workbooks listed
under the "source" heading? Thanks very much.

 

[Guest]

Sometimes you can and other times you can't. I tried to isolatte a problem
like this a month ago. Delete all the sheets one at the time until I found
the bad sheet. then I proceeded to delete all the data. When I got done I
had an empty workshhet and still had the error.

I did a binary search of the xls file a found the link was in the file, but
not in any cells nor the header or foooter. I finally updated the links in
the empty workbook and the problem went away.

 

[Guest]

Always an annoying problem. I can make few suggestions:

Try Edit Find and look for [*].
Try Insert Name Define and see if any defined names link to another file.
Look at any graphs you have and check the location of the source data.

I have run into the situation Joel described -- it's just plain weird.

Good luck.

 

[Peo Sjoblom]

Download and install this add-in by Bill Manville

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