Excel 2003 Memory Limits Up

  • Thread starter Thread starter Charles Williams
  • Start date Start date
C

Charles Williams

I have been doing some testing on Excel 2003, and Microsoft have
dramatically increased the workbook formulae memory and pivot table limits.

I got to 750MB of workbooks that are nearly all formulae without any
problems under Win XP (started getting a bit slow because I only have 768MB
RAM). This compares with a limit of about 80MB for Excel2000 and 160MB for
Excel2002.

I also successfully created a pivot table containing over 2 million rows.

If you work with large workbooks or pivot tables it is definitely worth
looking at Excel 2003.

regards
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com
 
Yes, I have updated the memory pages on my site.

Now what we really need is a system with 4Gigabytes of RAM for some
heavy-duty testing ....


regards
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com
 
Back
Top