Excel 2000 - Removing phantom links between workbooks

  • Thread starter Thread starter cdaubert
  • Start date Start date
C

cdaubert

My workbook is linked to another workbook. That link is useless.
tried changing the link so that it links to itself but then I get th
message:

"Your formula contains an invalid external reference to a worksheet.
Verify that the path, workbook, and range name or cell reference ar
correct, then try again." After clicking OK about 8 times, the messag
disappears.

I tried emailing this worksheet to an XP platform and saving it t
Excel (XP? 2003?) and changing the link there. That didn't wor
either. The newer version of Excel also has a Remove Link button, bu
that also failed. Please help! It is infuriating to have the workboo
prompt the user for a link upon opening that doesn't exist!!
 
Hi
maybe the following add-in will help you:
http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip

Frank
My workbook is linked to another workbook. That link is useless. I
tried changing the link so that it links to itself but then I get the
message:

"Your formula contains an invalid external reference to a worksheet.
Verify that the path, workbook, and range name or cell reference are
correct, then try again." After clicking OK about 8 times, the
message disappears.

I tried emailing this worksheet to an XP platform and saving it to
Excel (XP? 2003?) and changing the link there. That didn't work
either. The newer version of Excel also has a Remove Link button, but
that also failed. Please help! It is infuriating to have the
workbook prompt the user for a link upon opening that doesn't
Click to expand...
exist!!!
 
looked for the phantom link in "named ranges". go to the following menu: Insert, Name, Define and look through the defined names and you may see a link to the phantom spreadsheet. delete the named range and your problem should be fixed. good luck.
 
Back
Top