Copying Worksheets, Include Formulas

[brharrii]

I use Excel 2010 and windows XP. I'm trying to copy whole worksheets from one workbook to another. I have 10 old workbooks that I am trying to reduce to one new one. After I highlight and copy the worksheet I'll jump over to the new workbook and paste and I get this message:

The range you are pasting contains formulas that cannot be pasted into this instance of Excel; however, the formulas will be pasted as values. This may result from pasting fromulas from protected view, another instance of excel, or from another application.

the worksheet / workbook are not currently protected.

I'd prefer to retain the formulas if possible. it takes me a lot of time to go through the worksheet cell by cell and copy and paste each formula from each cell from the old worksheets to the new ones. is it possible to avoid this?

Thanks!

Bruce

[ben_hensel]

There are ways to explicitly move an entire worksheet to a new workbook.

My preferred method is, right-click the worksheet tab, select "Move or copy", and then select a different workbook from the first dropdown box.

Anyway, you might run into trouble going between XLS and XLSX formats, and locally named variables can cause a headache; are either of those cases applicable here?

[brharrii]

This works great, Thanks!

The one thing to note is that this will only work if both workbooks are open in the same instance of excel. That was ultimately the challenge I was having, is that both isntances were open seperately.

Thanks again!