You probably havve to copy each worksheet to a new worksheet one att a time.
After each worksheet open and close the new worksheet until you find the
problem worksheet. You may never find the problem. I never did. It could
be buried inside of excel where file in a place that can't be changed!

"Synapsless" wrote:

I did, yes. All links in the Edit Menu - Links show as "Status - OK" and they
are all links that I'm familiar with and did not come from the sheet that I
copied.

"Joel" wrote:

Did you try the Edit Menu - Links? I had a problem witth a link. I deleted
everything from the worksheet and never found the link. Then I broke the
link in the Edit menu and it disappeared.

"Synapsless" wrote:

I copied a sheet from another workbook as "Values Only". When I open the
workbook now I get a message "Workbook contains one or more links that connot
be updated". I can't seem to figure out where the links are in the workbook
and they do not pop up in my list of "Links..." I see no macros in the
workbook and I don't believe it would be in "Conditional Formatting" or
"Validation..." Any advice on where to look for this link or break it from
it's source to prevent the pop up message?

Synapsless