| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Poor Performance on LARGE Excel workbooks containing formulas
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Poor Performance on LARGE Excel workbooks containing formulas
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 "EricB" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Poor Performance on LARGE Excel workbooks containing formulas
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Poor Performance on LARGE Excel workbooks containing formulas
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 "Charles Williams" wrote: 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very poor performance with Excel 2007 | Excel Discussion (Misc queries) | |||
| poor macro performance | Excel Programming | |||
| Performance in excel 97 is poor | Excel Discussion (Misc queries) | |||
| poor subroutine performance | Excel Programming | |||
| Poor Worksheet Performance | Excel Programming | |||
Hybrid Mode
