Batch deleting invalid defined names from a workbook

[Guest]

I have inherited an excel file filled to the brim with obsolete name
definitions, numbering in the hundreds.

I would like a macro that loops through these names, see where they refer
to, and if they refer to any #REF!, or a particular external file that no
longer exist, to delete the name itself.

Any help would be appreciated.
Thanks

 

[Dave Peterson]

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

 

[Guest]

Thanks, I used it and believe it or not, the excel file had approximately
18,000 (eighteen thousand) invalid names.

The add-in took about 5 minutes just to display the list.

Cheers,

 

[Dave Peterson]

Wow! That's a lot of names and a lot of invalid names!