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.

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.
--
Regards,
Eddie
http://www.HelpExcel.com


"dhstein" wrote:

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.

HelpExcel.com;348796 Wrote:
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.
--
Regards,
Eddie
'HelpExcel.com' (http://www.HelpExcel.com)


"dhstein" wrote:

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.



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


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97540