HomeTechniques and TipsAll ProductsGetting Better Performance from Excel

1.4. Getting Better Performance from Excel

Disponible en español: Conseguir un mayor rendimiento de Excel
Disponível em português: Obtendo o melhor desempenho do Excel

Applies to: @RISK and other Palisade add-ins to Excel

How much of the calculation time in my model is actually spent by Excel? Can I make my Excel worksheets calculate more efficiently?

The impact varies. @RISK (particularly RISK Optimizer), Evolver, PrecisionTree with linked trees, and TopRank are most affected by Excel calculation speed.

Microsoft has a number of suggestions for how to get better performance out of your Excel model:

Last edited: 2015-04-10

This page was: Helpful | Not Helpful