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