Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move/Copy sheet to another workbook error | Excel Discussion (Misc queries) | |||
copy sheet error message | New Users to Excel | |||
Copy Worksheet Error Message | Excel Discussion (Misc queries) | |||
Cell Copy Error Message | Excel Discussion (Misc queries) | |||
Cell Copy Error Message | Excel Discussion (Misc queries) |