corrupted calc on sheet
 

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

corrupted calc on sheet
 

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