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