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.