Copy sheet to different workbook sizing error message

[Jvwulffen]

When trying to create a copy of a worksheet and inserting into a different
workbook I receive this error message:
excell cannot insert the sheets into the destination workbook, because it
contains fewer rows and columns than the source workbook. Goes on to tell me
to C&P into other workbook which I don't want to do.
I am fairly certain there is a way to "delete" the empty rows/columns taking
up space and making workbook larger than necessary giving me the ability to
then insert it into the other workbook.

 

[Luke M]

Save the source workbook with regular file extension, "xlsx", not the
extension used for larger file size.

 

[Gord Dibben]

Has nothing to do with deleting unused rows or columns.

You are trying to copy a sheet from a 2007 workbook into a 2003 workbook.

2007 has over a million rows and 16384 columns per sheet.

2003 has 65536 rows and 256 columns per sheet.


Gord Dibben MS Excel MVP