Is it possible to have more than 65,336 lines in one sheet?
 

Is it possible to have more than 65,336 lines in one sheet?

I have data to import that has 1,000,000 lines, is it possible to view in
one spreadsheet?

No, unfortunatelly not. Try importing your data into Access then querying it
from Excel.... Data-Import External Data-New Database Query.

--
Regards,
Dave
<!--


"Lauren" wrote:

Is it possible to have more than 65,336 lines in one sheet?

I have data to import that has 1,000,000 lines, is it possible to view in
one spreadsheet?

No

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Lauren" wrote in message ...
Is it possible to have more than 65,336 lines in one sheet?

I have data to import that has 1,000,000 lines, is it possible to view in
one spreadsheet?

Afraid not, 256 columns and 65,536 rows are written in stone,
Regards,
Alan.
"Lauren" wrote in message
...
Is it possible to have more than 65,336 lines in one sheet?

I have data to import that has 1,000,000 lines, is it possible to view in
one spreadsheet?

Is it possible to have more than 65,336 lines in one sheet?
 

I have heard that Excel 2007 will allow more; it will only be limited by your
system memory. Don't hold me to it but it was in one of my pc magazines a
while back...

"Lauren" wrote:

Is it possible to have more than 65,336 lines in one sheet?

I have data to import that has 1,000,000 lines, is it possible to view in
one spreadsheet?

Is it possible to have more than 65,336 lines in one sheet?
 

Excel 2007 has - are your ready for this? - 1 millions rows
Oh what scope for misuse!!!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Stephen Jame Pattenden"
wrote in message ...
I have heard that Excel 2007 will allow more; it will only be limited by
your
system memory. Don't hold me to it but it was in one of my pc magazines a
while back...

"Lauren" wrote:

Is it possible to have more than 65,336 lines in one sheet?

I have data to import that has 1,000,000 lines, is it possible to view in
one spreadsheet?