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

Hi Danny,

Try rebuilding the calculation dependency tree with

CTRL+ALT+SHIFT+F9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan" <(E-Mail Removed)> wrote in message news:170E694E-F34B-4178-B20C-(E-Mail Removed)...
| 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