If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy sheet to different workbook sizing error message
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. |
#2
|
|||
|
|||
Copy sheet to different workbook sizing error message
Save the source workbook with regular file extension, "xlsx", not the
extension used for larger file size. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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. |
#3
|
|||
|
|||
Copy sheet to different workbook sizing error message
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. |
Thread Tools | |
Display Modes | |
|
|