Help copy excel 2007

  • Thread starter Thread starter jjmmdanp
  • Start date Start date
J

jjmmdanp

Hello !

I have 2 files from excel 2007 and i want to copy one "leaves" to the
other file, but i got the next message: "Excel can´t insert all
"leaves" in the destiny book, because this contain less lines and
columns at origin book" sory my english. I create more lines and
columns in the destiny file but i got the same message !!

Can someone help me ?

Thanks

João

Portugal
 
I got an error message similar to yours when I tried to copy a sheet from an
Excel 2007 workbook (with 1,048,576 rows) to a workbook that is in
"compatibility mode" and therefore has only 65536 rows. This is because
compatibility mode only supports the limitations in Excel 2003. Check to
see that your destination workbook has 1,048,576 rows and if not try using
File, Convert on the Office menu to upgrade it.


--
Jim
Hello !

I have 2 files from excel 2007 and i want to copy one "leaves" to the
other file, but i got the next message: "Excel can´t insert all
"leaves" in the destiny book, because this contain less lines and
columns at origin book" sory my english. I create more lines and
columns in the destiny file but i got the same message !!

Can someone help me ?

Thanks

João

Portugal
 
I got an error message similar to yours when I tried to copy a sheet froman
Excel 2007 workbook (with 1,048,576 rows) to a workbook that is in
"compatibility mode" and therefore has only 65536 rows.  This is because
compatibility mode only supports the limitations in Excel 2003.  Check to
see that your destination workbook has 1,048,576 rows and if not try using
File, Convert on the Office menu to upgrade it.

--

Hello !

I have 2 files from excel 2007 and i want to copy one "leaves" to the
other file, but i got the next message: "Excel can´t insert all
"leaves" in the destiny book, because this contain less lines and
columns at origin book" sory my english. I create more lines and
columns in the destiny file but i got the same message !!

Can someone help me ?

Thanks

João

Portugal
Click to expand...

Thanks Jim. I use your suggestion and i upgrade the file and now works
fine.

Thanks.

JM
 
Back
Top