Edit Links - cannot change source

[Code Numpty]

I have a file that when it opens I get the warning saying cannot update
links. When I open the Edit Links dialog the problem file is listed as
Source Not Found.

However, there are no links to this file in my spreadsheet. I have used Edit
Find with the filename and also Edit Find to check every single link. It is
not there.

Change Source does not work, nothing happens. Break Link doesn't work
(although I want other links to remain!).

I reinstated the problem file and then tried using Edit Links to change the
source etc. but still no luck.

I need to be able to distribute this file to others without the message
appearing, yet I need some users to be able to choose whether to update links
or not when they open it.

Please help.

 

[Ashish Mathur]

Hi,

You probably have named ranges which result in an error. Please press
Ctrl+F3 and you will be able to see the named ranges which yield errors.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Code Numpty]

Thanks Ashish. I get a couple of named ranges Refers to: for example
='Engineers Worksheet'!#REF!

I deleted these named ranges, saved the file and re-opened it but still get
the Error source not found.

 

[Dave Peterson]

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

 

[Code Numpty]

Thanks Dave. It was a Combination Drop Down, found straight away by Bill's
add in.