corrupted calc on sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

| 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

check if excel sheet in manual calc mode 1
Corrupted sheet - What the cause? 2
AutoCalc Worksheet in ManualCalc Workbook 2
Excel Range calculation breaking application.calculate - horrifyingproblem 8
Weird calc behavior - Guru challenge? 1
Manual Calc in a loop issue 7
=ISODD Behaving Oddly 5
Simple +formula not reading value from the reference cell 4

Back
Top