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.