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

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).


On Sun, 1 Aug 2004 21:43:01 -0700, "latha"
wrote:

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

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" wrote in message
...
Can anyonetell me how to remove all the reference names (external_data_1)
in the sheet except my own created name references.
--
Soly

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

latha wrote:

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

--

Dave Peterson