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.