Change the formula to text by inserting a ' in front.
Then copy /paste, and remove the '.

--
Greetings from New Zealand
Bill K
"Ineluctable" wrote in message
...
How do I copy & paste formulas without the formulas linking back to the
original source spreadsheet. The formulas should calculate only from
internal cells and tabs .