Wrong amount or calculation error?

[Guest]

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.

 

[Niek Otten]

Very, very rarely, Excel loses track of the dependencies. CTRL+SHIFT+ALT+F9 rebuilds the dependency tree (I think from Excel 2002
upwards, but I'm not sure)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.