Thanks Frank, but that means I have to edit each and every formula in the
target location. If I have to do that then I can just as easily remove the
reference to the source from the same formula.

"Frank Kabel" wrote:

Hi
one way:
- make a backup of your source file :-)
- in your source sheet replace the equation sign with $$$$ ('Edit -
Replace')
- copy your source sheet to its new location
- in the target location replace '$$$$' with an equation sign '='

--
Regards
Frank Kabel
Frankfurt, Germany

"Bruce the Battler" <Bruce the
schrieb im Newsbeitrag
...
I wish to copy a formula to another workbook but need to break the
link so
the formula refers to a worksheet by the same name in the new
workbook ie: I
wish to paste a worksheet containing formulas into a number of other
workbooks and that new worksheet has look-up formulas that refer to
worksheets of the same name in each workbook.