I have an Excel spreadsheet containing many sheets, most of which have formulas.

I have managed to copy most of the sheets (with formulas) into a new Excel file. To copy the sheets I used Copy and Paste Special, selecting all. This works in most cases.

I have one problem sheet from which I am unable to copy the formulas over to my new file.

Firstly by using Paste Special I got `#REF`

in all of the cells. I then used Copy, Paste Values, then copy again and paste formulas. The two sheets match but the formulas don't copy over.

If I paste formulas, the `#REF`

comes up in the boxes.