Re: Causes Of Workbook Recalculating
Taken from the site I posted for you:
QuoteThe time taken by Excel to work out the calculation sequence can be increased by heavy use of functions such as INDIRECT and OFFSET which increase the complexity and volatility of the dependency tree.
Just to note as well, the following link is on that site, if you want to get really confused or enlightened about the calculation process:
http://%22http//msdn.microsof…a140058.aspx%22