MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Ghost links


Posted by Lieuwe on June 20, 2001 3:06 AM

In my excel application there are a number of ghost links. When opening the application (Spreadsheet)then its asks to update the links. Howeffer there are no links.
This problem has been caused by moving sheets out of the workbook to an other workbook by a faulty macro.

The question is: How do I remove these links?


Posted by Aladin Akyurek on June 20, 2001 3:44 AM

One place to look for is the names space. Activate the option Insert|Name|Define. See if there are any names whose references contain the #REF bit. You can delete them.

Aladin