Removing links to other worksheets from within a workbook
 

I have developed a 400-worksheet workbook and during its evolution I have
copied some cells from other worksheets. This has created references to other
worksheets that no longer exist, so whenever I open the workbook I get the
annoying messages relating to "links not found". I am using Excel 2002. When
I select Edit/Links then it shows the offending 4 non-existent spreadsheets
but I cannot locate the cells that reference them. When I use the Edit/Find
and select Options/Within-Workbook to try to locate the spreadsheet
references to these non-existent spreadsheets, no cell references are located
by the "Find".
Can anyone suggest how I can locate these "phantom" references and get rid
of them???
--
Thanks, Richard.

Did you use lookup functions anywhere... or lists. Try Insertnamesdefine
and check if any lists defined there point to these worksheets. Remove them
and that should do the trick.

Also if you have any macros calling these worksheets edit them.

Both these things don't show up in the 'Find' command

vikrant

"rjb" wrote:

I have developed a 400-worksheet workbook and during its evolution I have
copied some cells from other worksheets. This has created references to other
worksheets that no longer exist, so whenever I open the workbook I get the
annoying messages relating to "links not found". I am using Excel 2002. When
I select Edit/Links then it shows the offending 4 non-existent spreadsheets
but I cannot locate the cells that reference them. When I use the Edit/Find
and select Options/Within-Workbook to try to locate the spreadsheet
references to these non-existent spreadsheets, no cell references are located
by the "Find".
Can anyone suggest how I can locate these "phantom" references and get rid
of them???
--
Thanks, Richard.

Hi RJ,

Try Bill Manville's Findlink Addin available for free download at Chip
Pearson's site:

http://www.cpearson.com/excel/xltools.htm



---
Regards,
Norman



"rjb" wrote in message
...
I have developed a 400-worksheet workbook and during its evolution I have
copied some cells from other worksheets. This has created references to
other
worksheets that no longer exist, so whenever I open the workbook I get the
annoying messages relating to "links not found". I am using Excel 2002.
When
I select Edit/Links then it shows the offending 4 non-existent
spreadsheets
but I cannot locate the cells that reference them. When I use the
Edit/Find
and select Options/Within-Workbook to try to locate the spreadsheet
references to these non-existent spreadsheets, no cell references are
located
by the "Find".
Can anyone suggest how I can locate these "phantom" references and get rid
of them???
--
Thanks, Richard.