My company just upgraded to Excel 2007. I am having trouble copying a
worksheet using the "Move or Copy" function.

When i try to copy one worksheet to another, I get an error dialog box that
states "Excel can't insert the worksheets into the destination workbook
because it contains fewer rows or columns then the source workbook." This
was not a problem in our prior version of excel.

I have saved both source workbooks as 2007 but that didn't help.

Any suggestions?

You need to first seutp your destination workbook to have the larger
worksheets. Default sheet is 256 columns/65356 rows, but in 2007 you can
expand this. I believe you need to save it as a different file extension
(just look at whatever type your source workbook is saved as)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"lionking" wrote:

My company just upgraded to Excel 2007. I am having trouble copying a
worksheet using the "Move or Copy" function.

When i try to copy one worksheet to another, I get an error dialog box that
states "Excel can't insert the worksheets into the destination workbook
because it contains fewer rows or columns then the source workbook." This
was not a problem in our prior version of excel.

I have saved both source workbooks as 2007 but that didn't help.

Any suggestions?

On Tue, 10 Nov 2009 08:46:04 -0800, Luke M
wrote:

You need to first seutp your destination workbook to have the larger
worksheets. Default sheet is 256 columns/65356 rows, but in 2007 you can
expand this. I believe you need to save it as a different file extension
(just look at whatever type your source workbook is saved as)


Compatibility mode.

Save as, and choose Excel 97 - 2003 workbook for your 'new' workbook.

Then, you should be able to perform the copy routine.

IF your 'new' workbook has more than 256 columns or 65535 rows, the
file will fail to open in the Excel 2003 application.

It will always open in the Excel 2007 version.

You can also download an excel 2007 compatibility patch for any
machines
you intend to keep at the 2k3 level. This still makes 2003 files, but
allow you to read *some* workbooks made under the 2k7 version. Editing
may or may not be available on a 2k7 workbook opened from within 2k3
version of Excel.