Prev: Excel 2007 Traffic Light with dates
Next: Outlook 2007 crashes
From: Jvwulffen on 20 Nov 2009 14:14
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.
From: Luke M on 20 Nov 2009 16:02
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.
From: Gord Dibben on 20 Nov 2009 16:36
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
<Jvwulffen(a)discussions.microsoft.com> 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.

 | 
Pages: 1
Prev: Excel 2007 Traffic Light with dates
Next: Outlook 2007 crashes