removing links to external workbooks
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
|