Excel 2007:
I have two workbooks, both are .xls's. I'm trying to copy a worksheet from the first workbook in to the second workbook. When I right click the worksheet and select "Move or Copy", I get an error saying that the number of columns and rows in the first workbook exceed the number of columns and rows in the second workbook.

The first workbook has the increased number of columns and rows, whereas the second workbook is limited to 256 / 65k respectively. No matter what file format I save either workbook as, the number of columns and rows are unaffected.

How can I copy a worksheet from a workbook that has too many row and columns (even though I'm only using a few of each) in to a workbook that is limited to the pre-Excel 2007 amounts? Please note that I can't simply copy/paste the data as I need to retain the page setup from the first workbook as well.


I can copy from the second workbook to the first, but it has several worksheets which take 5 times the number of clicks to copy over. It's much easier to go from the first workbook to the second.


Thanks.