|
| 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
May 18th, 2009, 12:53 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
May 18th, 2009, 02:59 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 18th, 2009, 10:31 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
