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

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.

"Shooter" wrote:

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

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.

"Shooter" wrote:

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

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