Excel technical issue - Iterative Calculations slowing down Excel?

[3G]

Hi there-

I was practicing Chandoo's circular reference/in-cell chart function lesson whereby you change the iterative calculations & whatnot.


Ever since doing that, my Excel has been significantly slower, and, I am now getting this message in the lower right hand corner of Excel showing my processors in use and the %.


What are the defaults to set it BACK? Not sure if that's causing the problems,but it's been much slower since then.


Thanks!

3G

 

[jeremymjp]

Dunno if that's THE reason, but to disallow iterative calculations:


1) Go to File > Options (in 2010). I think 2007 it is Excel Options from the Windows button.


2) In the "Formulas" tab, uncheck the box that says "Enable Iterative Calculations".


Hope that's all it is....

 

[prasaddn]

you can try max iterations to 100 and max change to 0.001. It depends on versions as well. Another eazy option may be disable iterative calculations by unchecking the option.