G
Guest
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???
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???