Understanding the Message “Workbook contains . . . links that cannot . . .”

[SidBord]

I have a relatively new workbook that I’ve been developing for a few weeks mostly without Win 7 problems . Then today whenever I open the workbook I started getting the old friend message:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
“This workbook contains one or more links that cannot be updated.”
<o></o>
When I open the links for editing, I see there are 5 workbook names in the list.

<o></o>
Under the heading “Type” all entries have the value “Worksheet”.

Under “Update” all entries have “A” (which I’m guessing means “Automatic”).

Under “Status” all entries have “OK”. However, when I fiddle around with things, all the ”Status” values change to “Unknown”. If I press the button “Check Status”, all entries that were “Unknown” change back to “OK”.
<o></o>
Jeez, I hate when this happens. Does it strike you that there’s something a little weird about a message that says something is wrong, then shows a status of “OK”?

How do I interpret this message? What does it want me to do? The workbook seems to be functioning OK.
Sid

 

[xenou]

See the Quaker dude's third post here:
http://www.mrexcel.com/forum/showthread.php?t=308563&highlight=edit+links+continue

A number of users have found that this is solved by cleaning up their defined names and removing those that have ref# errors.

 

[SidBord]

Hey, XENOU! You solved my message problem. I went through and cleaned up (deleted and recreated) all my Defined names, and .. Voila! ... the message no longer occurs.

I can't thank you enough, Guy!
Sid