I have a medium size but simple construction estimating spreadsheet in Excel
2003. Each worksheet carries forward its totals to the front (recap) sheet
of the workbook. We recently had an isolated problem where this recap sheet
shows incorrect or uncalculated amounts but the worksheet the totals came
from are correct. The formulas are unchanged and correct. The cells are
formatted as number. Calculation is automatic. I did find that the amounts
corrected by using the shortcut Ctrl+Alt+F9. It does not change with F9 or
Shift+F9.