If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculation
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. |
#2
|
|||
|
|||
Calculation
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. |
#3
|
|||
|
|||
Calculation
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 |
Thread Tools | |
Display Modes | |
|
|