Excel 2003 Memory Limits Up

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
 
C

Charles Williams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any different between Excel 2007 and 2003 on formula memory? 1
Performance on calculation - 2003 vs 2007 5
OFFSET and UDF bug 2
NEED MORE MEMORY THAN EXCEL 2003 HAS FOR LARGE COMPLICATED WORKBO. 3
2000 - 2003: different memory usage when creating pivot tables 1
Maximum number of worksheets in Excel 2003 1
Understanding the Cell Microprocessor [VERY LONG] 12
Beyond3D article on ATI 'Xenos' - the graphics processor of Xbox 360 1

Top