Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

The copied formulas probably have references to other sheets of the same file. They contain references like this: mysheet!A5

If you copy them to a new file, you have to name the sheets with the exact name (mysheet in my example), so the copied formulas will work inside the new file.

It could be simpler to just copy the whole file and give it a different name, then delete the parts you don't want.

share|improve this answer
    
I like the idea of copying the file and deleting the parts that she doesn't need. This is how many people tend to do it. –  user3463 Apr 25 '12 at 16:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.