Copy sheet between workbooks

[polska21800]

I'm having an issue where I copy a sheet from one workbook to another and it links the formulas to the original workbook, even when I do past special formulas. Any suggestions.

[Richard Buttrey]

Hi,

How about Paste Special Values?

Regards

[MSP]

If you paste special values it will only copy what's in the cell. It won't copy the formulas along with it. I'm guessing that's what youre looking for? If you paste formulas, you will get N/A# or VALUE#! in every cell.

[polska21800]

If I do past specials formulas it gives me the right answer however thats because its linked to the original workbook if I move/rename the workbook it gives me n/a# and value#! depending on the cell.