Download and install this add-in by Bill Manville

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


--
Regards,

Peo Sjoblom



"Shooter" wrote in message
...
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.
--
Shooter