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.