How to find and remove/revise external cell references? Series of "File not
found" happens on opening workbook and is from prior cut and paste I
assume... don't know where the references are held so can't revise or delete.

Version? Try this:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Ed" wrote in message
...
How to find and remove/revise external cell references? Series of "File
not
found" happens on opening workbook and is from prior cut and paste I
assume... don't know where the references are held so can't revise or
delete.

Ed

Maybe not looking for links.

The series of "file not found" could arise from Excel's file association being
broken.

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Gord Dibben Excel MVP


On Tue, 20 Sep 2005 11:46:17 -0700, "Ed" wrote:

How to find and remove/revise external cell references? Series of "File not
found" happens on opening workbook and is from prior cut and paste I
assume... don't know where the references are held so can't revise or delete.