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

On Fri, 20 Nov 2009 11:14:02 -0800, Jvwulffen
wrote:

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.