Batch deleting invalid defined names from a workbook
 

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

Batch deleting invalid defined names from a workbook
 

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

hugehead wrote:

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

Batch deleting invalid defined names from a workbook
 

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" wrote:

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

hugehead wrote:

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

Batch deleting invalid defined names from a workbook
 

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

hugehead wrote:

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" wrote:

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

hugehead wrote:

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


--

Dave Peterson