Try it in this way ..

First, ensure that all dependent sheetnames referenced by the formulas
within the sheet(s) to be copied over actually *exist* within the
destination book before proceeding ..

In the source book,
(Do this one sheet at a time)

Select the entire sheet to be copied
Click Edit Replace
Find what: =
Replace with: zzzzz
Click Replace All
(this effectively "neutralizes" all formulas on the sheet)

Then copy n paste the sheet over to the destination book,
and reverse the process ..

Select the entire sheet (which is copied over)
Click Edit Replace
Find what: zzzzz
Replace with: =
Click Replace All
(Array formulas, if any, would need to be re-entered using CSE & re-filled)

Repeat process for next sheet ...
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mick" wrote in message
...
Hi

When copying a worksheet from one spreadsheet another spreadsheet, the
formulas maintain the link to the data in the original spreadsheet, is
there a way of copying the worksheet so that it does not reference the
original spreadsheet.

Many thanks
Mick