I'll qualify that to add given the assumptions I previosly stated.

--
Regards,
Tom Ogilvy


"ll" wrote in message
oups.com...
Dave,
Thanks so much for this - I've integrated it successfully with my
script, and now external links are gone. :-)
Kind Regards,
Louis


On Feb 14, 12:00 pm, Dave Peterson wrote:
Select the range to fix:
edit|replace
what:[*]
with: (leave blank)
replace all

=========
Alternatively, before you copy, you could use this technique:

Convert the formulas to strings, copy the worksheet, and convert those
strings
back to formulas.

I like to do this:

Select all the cells
edit|Replace
what: = (equal sign)
with: $$$$$=
replace all

Then the copy.

And reverse the process:

Select all the cells
edit|Replace
what: $$$$$=
with: =
replace all