Spreadsheet won't calculate

[frankfine]

I have a large spreadsheet that will not calculate the most simple of formulas.
- auto calculate is on.
- it still won't calculate using F9.
Any suggestions?

 

[Niek Otten]

http://xldynamic.com/source/xld.xlFAQ0024.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a large spreadsheet that will not calculate the most simple of formulas.
| - auto calculate is on.
| - it still won't calculate using F9.
| Any suggestions?

 

[ed]

http://xldynamic.com/source/xld.xlFAQ0024.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a large spreadsheet that will not calculate the most simple of formulas.
| - auto calculate is on.
| - it still won't calculate using F9.

Any suggestions?|

On the same menu as Calculatio/automatic be sure that Iterations is set
to at least 100.

 

[frankfine]

Thank you. It was the cell formatting that caused the problem. I had to
reset all cells to "General", and later reformat cells as needed.