Worksheet row limitations.
 

When I attempt to paste data in excess of 65,000 lines to an new blank Excel
2007 worksheet I get the message "files not loaded completely" with an
explanation that the file contains more than 1,046, 576 rows..., In fact the
file I am trying to paste does not have anywhere near that amount?

I have been able to work around this by converting files previously created
in Excel 2003, but wonder why I have to do this rather than just creating a
new worksheet in 2007?
--
Dbogart

Worksheet row limitations.
 

What is the row limit for Excel 2007?


"DBogart" wrote in message
...
When I attempt to paste data in excess of 65,000 lines to an new blank
Excel
2007 worksheet I get the message "files not loaded completely" with an
explanation that the file contains more than 1,046, 576 rows..., In fact
the
file I am trying to paste does not have anywhere near that amount?

I have been able to work around this by converting files previously
created
in Excel 2003, but wonder why I have to do this rather than just creating
a
new worksheet in 2007?
--
Dbogart

Worksheet row limitations.
 

Hi DBogart

to an new blank Excel
2007 worksheet

If your Default Save format in Excel 2007 is a 97-2003 workbook you only have 65000+ rows

Change it here to a 2007 format : Office buttonExcel options...Save



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DBogart" wrote in message ...
When I attempt to paste data in excess of 65,000 lines to an new blank Excel
2007 worksheet I get the message "files not loaded completely" with an
explanation that the file contains more than 1,046, 576 rows..., In fact the
file I am trying to paste does not have anywhere near that amount?

I have been able to work around this by converting files previously created
in Excel 2003, but wonder why I have to do this rather than just creating a
new worksheet in 2007?
--
Dbogart