Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Iterating rows, calc cells in dynamic sheet | Excel Programming | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
Suspend calc of formula using a non-existent sheet | Excel Discussion (Misc queries) | |||
Worksheet Calc Gets Stopped When Sheet is Clicked | Excel Programming | |||
How to make sheet continuosly re-calc | Excel Programming |