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?