Calculation

D

dhstein

I'd like to speed up the calculations on the spreadsheet. As a first step,
is it true that only cells that get changed and those cells that have
dependencies based on the changed cells, get recalculated? Thanks for any
help on this.
 
H

HelpExcel.com

I would set calculation to manual as a first step to speeding up calculating.
I would then set a collection of cells that "need" re-calculating and calc
them on an individual basis.
 
P

Pecoflyer

HelpExcel.com;348796 said:
I would set calculation to manual as a first step to speeding up
calculating.
I would then set a collection of cells that "need" re-calculating and
calc
them on an individual basis.
Click to expand...

Hi, also avoid volatile functions ( see 'Volatile Excel Functions
-Decision Models' (http://www.decisionmodels.com/calcsecretsi.htm)) and
unnecessary calculations on entire columns
 
Top