External Workbook Link

[Colin Morse]

I cannot delete a link to another xl workbook that no longer exists.
Each time i go to change links to the current or any other worbook a
message comes back saying, Your formula contains invalid external
reference to a worksheet.
I have actually inserted a new worksheet and deleted all the other
sheets one at a time to try and find the cause, but it still stays
linked to the other workbook.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Max]

Try Bill Manville's excellent FindLink utility
It's available at Stephen Bullen's page:

http://www.bmsltd.ie/MVP/Default.htm

 

[Dave Hawley]

Hi Colin

This page will solve your problem.

http://www.ozgrid.com/Excel/ExcelProblems.htm

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***