M
Michael J. Malinsky
Excel will not allow 1 million rows...it's limit is 65535
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
sue
I'm running Excel 2000 under windows NT. I have a user
who wants to import 1 millions rows of data into Excel and
process with pivot tables. I've never worked with that
many rows in Excel. Wouldn't it run awfully slow? I'd
appreciate your comments!
Sue
who wants to import 1 millions rows of data into Excel and
process with pivot tables. I've never worked with that
many rows in Excel. Wouldn't it run awfully slow? I'd
appreciate your comments!
Sue
A
Anders S
Sue
An Excel sheet has a maximum of 65536 rows. There is no practical workaround, especially if you want to use Pivot Tables.
Regards
Anders Silvén
An Excel sheet has a maximum of 65536 rows. There is no practical workaround, especially if you want to use Pivot Tables.
Regards
Anders Silvén
A
Alan
Sue,
Sorry but the maximum size of an Excel worksheet is 256 (A:IV)
columns x 65536 rows. Written in stone I'm afraid.
Sorry but the maximum size of an Excel worksheet is 256 (A:IV)
columns x 65536 rows. Written in stone I'm afraid.
H
Harald Staff
Hi Sue
Excel has max 65536 rows per sheet. Pivot tables will also work with externa data, like
from a database, but since they reside in spreadsheets I believe they might run into the
65k limitation and strike/scream/die if the choice of fields is wrong.
Excel has max 65536 rows per sheet. Pivot tables will also work with externa data, like
from a database, but since they reside in spreadsheets I believe they might run into the
65k limitation and strike/scream/die if the choice of fields is wrong.
K
Ken Wright
Whilst you can get round the limit by spreading the data across different sheets
using the feature to start at a certain row when importing (Manula process
though), you are quite correct in that it will run like an absolute dog, if at
all. Tell him to use Access.
using the feature to start at a certain row when importing (Manula process
though), you are quite correct in that it will run like an absolute dog, if at
all. Tell him to use Access.
C
Charles Williams
Hi Sue,
1 million rows is pushing the limits:
although Excel has a limit of 65000 rows this does not apply to pivot tables
if they get their data from an external database.
Instead the overall Excel memory limits apply.
I recently ran some tests on importing records from an access database using
ADO. The results for this particular pivot table were:
Excel 2000 about 500K records max
Excel 2002 about 1000K records max
Excel 2003 Beta version; limit not found: read 2.3 million records in 8
minutes on my system (AMD 1200 MHZ with
768MB RAM).
Note that the limits also depend on how many columns etc there are in the
data.
If you create an OLAP Cube (see OLAP in Excel Help) then you will be able to
use a larger number of records than the limits shown above, but it will run
a lot slower.
regards
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com
1 million rows is pushing the limits:
although Excel has a limit of 65000 rows this does not apply to pivot tables
if they get their data from an external database.
Instead the overall Excel memory limits apply.
I recently ran some tests on importing records from an access database using
ADO. The results for this particular pivot table were:
Excel 2000 about 500K records max
Excel 2002 about 1000K records max
Excel 2003 Beta version; limit not found: read 2.3 million records in 8
minutes on my system (AMD 1200 MHZ with
768MB RAM).
Note that the limits also depend on how many columns etc there are in the
data.
If you create an OLAP Cube (see OLAP in Excel Help) then you will be able to
use a larger number of records than the limits shown above, but it will run
a lot slower.
regards
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com