you should get the findlink tool http://www.oaltd.co.uk/MVP/Default.htm

"Paul Martin" wrote in message
...
| Hi all
|
| I've converted a large file from XL03 to XL07 and have a recurring
| problem with "Edit Links" on startup. When I open the workbook, I get
| a message "This workbook contains one or more links that cannot be
| updated". When I click on "Edit Links", the Source is the first
| worksheet and the status is "Error: Source not found".
|
| I've tried to Change Source to the current workbook and also I've
| tried Break Link. Both of these appear to work, but when I save,
| close and reopen the workbook, the problem returns. Strangely,
| though, it's sporadic and doesn't occur every time I open the
| workbook.
|
| The supposed link is to a non-existent workbook with the name of the
| first sheet, eg "Sheet1.xls" so obviously something has gone awry. I
| cannot find "Sheet1.xls" (not its real name) in any formulae, the list
| of names nor in the chart on the sheet. I've looked through the chart
| series and labels, all to no avail.
|
| Any suggestions are appreciated.
|
| Thanks in advance
|
| Paul Martin
| Melbourne, Australia