Worksheets not feeding each other properly

[John]

Have multiple worksheets that feed into each other. When
I change a number in one of the worksheets it is not
changing the number on the other worksheet without me re-
linking the cell again. I tried hitting F9, did not
change the iterations, and closed in and out of the
program without any luck. Please help.

 

[Niek Otten]

Most frequent reasons for not recalculating:

A. Automatic calculation is an Excel-wide setting. if you load a workbook
which has Manual calculation and then load another workbook which had
Automatic calculation, they'll both be set to Manual calculation.
B. Excel 5.0a and Excel 97 without Service Release 2 have recalculation
bugs. Update to a newer version (for Excel 97, that is, apply SR2)
C. User defined Functions (UDFs) should have all direct precedent cells in
the argument list. If you address a cell directly from within the UDF, Excel
doesn't know so it doesn't know when to recalc. This is true for both VBA
and Excel4 functions.
D. Very rarely (really, very, very, rarely!) Excel loses track of
dependent/precedent cells. In ExcelXP you can rebuild the dependency tree by
pressing CTRL+SHIFT+ALT+F9