View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ed ed is offline
external usenet poster
 
Posts: 82
Default Spreadsheet won't calculate


Niek Otten wrote:
http://xldynamic.com/source/xld.xlFAQ0024.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"frankfine" wrote in message ...
|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.