Thread: Calculation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
HelpExcel.com[_2_] HelpExcel.com[_2_] is offline
external usenet poster
 
Posts: 39
Default 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.