Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help! Names defined in Excel 2003 invalid in Excel 2007 | Excel Discussion (Misc queries) | |||
invalid names were detected in this workbook | Charts and Charting in Excel | |||
Exceeding 65K of defined names within workbook causes workbook to go into repair mode when it is opened | Excel Programming | |||
Renaming Invalid Defined Names | Excel Programming | |||
Deleting unused Defined Names in a workbook? | Excel Programming |