ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Optimization Tips (https://www.excelbanter.com/excel-discussion-misc-queries/109831-optimization-tips.html)

Aryn-Leah Adelman

Optimization Tips
 
Does anyone have any optimization tips for using Excel with complex models.
These models cause Excel to run extremely slow and to sometimes crash and
corrupt the models. I am wondering if there are any Excel configurations,
which help to alleviate the amount of memory eaten up by all the background
processes in Excel and also any formula optimization tips.

Thanks.



Gord Dibben

Optimization Tips
 
Charles Williams has some great info on his site dealing with speeding up
calculations.

http://www.decisionmodels.com/



Gord Dibben MS Excel MVP

On Wed, 13 Sep 2006 15:45:57 -0700, "Aryn-Leah Adelman"
wrote:

Does anyone have any optimization tips for using Excel with complex models.
These models cause Excel to run extremely slow and to sometimes crash and
corrupt the models. I am wondering if there are any Excel configurations,
which help to alleviate the amount of memory eaten up by all the background
processes in Excel and also any formula optimization tips.

Thanks.




All times are GMT +1. The time now is 09:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com