Hi Danny,

Try rebuilding the calculation dependency tree with

CTRL+ALT+SHIFT+F9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan" wrote in message ...
| One of my sheet got corrupted and calculation were done only after pressing
| F9 even though that the setup was on automated calc. Opening the sheet in
| Repair mode did not solve the problem.
|
| Any idea what has caused it and how to repair it (Excel working fine with
| other sheets but not on that one).
|
| Many thank
| Dan