I have received questions from some of you in reference to an error message that Excel can give which states:

“Microsoft Excel cannot calculate a formula. There is a circular reference in an open workbook, but the references that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the Undo command (Edit menu).”

I thought that this setting was workbook specific but apparently I was wrong. To fix this problem go to Tools–>Options–>Calculation tab: Put a check in the ‘Iteration’ checkbox and put a 1 where it says Maximum Iterations, Maximum change .001.

Sorry for any confusion