Poor Performance on LARGE Excel workbooks containing formulas

[EricB]

Is there a way to increase System Memory to handle large Work Books on
Excel2003? I get numerous "Not Responding" messages on large files. 22MB +
..... Numrous formular are contained in the workbooks and i can thus not
convert to .csv

 

[Bernie Deitrick]

Many times formulas can be replaced by pivot tables, but it is hard to say given the lack of detail
here.

Take a look here for the Excel pages:

http://www.decisionmodels.com

HTH,
Bernie
MS Excel MVP

 

[Charles Williams]

22MB is not that large. Does not sound like a memory problem to me.

There is a lot of info about Excel memory and speeding up workbooks at
http://www.decisionModels.com


Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[EricB]

My Work Book contains:
Front sheet containing numerous 'SUMPRODUCT' & Limited 'COUNTIF' formulas.
Historic information is copied & pasted as 'VALUES'.
3 X Graphs
Filtered data reads from the front sheet with Value = Value.
Raw data contains some 50.000 lines & 38 columns. Range from 1.5 to 2
Million Cells of Data.

The WEB page gives some download options but 'our' business security
policies are stopping me from downloading the files due to "Possible Security
Threat".

Does this help?

regards

EricB