Remove reference names

L

latha

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

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
Click to expand...
the sheet except my own created name references.
 
T

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

latha said:
Can anyonetell me how to remove all the reference names (external_data_1)
Click to expand...
in the sheet except my own created name references.
 
D

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
 
Top