Remove reference names

[Guest]

Can anyonetell me how to remove all the reference names (external_data_1) in the sheet except my own created name references.

 

[Myrna Larson]

Assuming you want the formulas to point to cells in the current workbook, go
to Edit/Links, select the links you want and change the source to point to the
workbook containing the formulas (i.e. to itself).

Can anyonetell me how to remove all the reference names (external_data_1) in

the sheet except my own created name references.

 

[Frank Kabel]

Hi
try the following add-in to find/delete links:
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

 

[Tom Ogilvy]

You can loop through the names collection and delete the offending names.
Not knowing anything about your created names, I can't tell you how to
differentiate which to keep and which to delete. As a worst case, you would
need a list of one or the other and check against that list.

--
Regards,
Tom Ogilvy

Can anyonetell me how to remove all the reference names (external_data_1)

in the sheet except my own created name references.

 

[Dave Peterson]

If this is a manual effort (one time thing)...

Download Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager.

You can find it at:
NameManager.Zip from http://www.bmsltd.ie/mvp