From the Help file:
When are existing formulas recalculated? Excel recalculates those cells
that are dependent on other cells that contain changed values. This type of
calculation helps to avoid unnecessary calculations. Excel also calculates
workbooks each time they are opened.
Background calculation As calculation proceeds, you can choose commands
or perform actions such as entering numbers or formulas. Excel temporarily
interrupts calculation to carry out the other commands or actions and then
resumes calculation. The calculation process may take more time if the
workbook contains a large number of formulas, or if the worksheets contain
data tables or functions that automatically recalculate every time the
workbook is recalculated. Also, the calculation process may take more time
if the worksheets contain links to other worksheets or workbooks. You can
control when calculation occurs by changing the calculation process to
manual calculation.
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
