Hello All,
Really bizarre thing here. Under Tools>Options>Calculation I keep checking the Automatic calculation, unchecking Iterations and making the max interations 100. I think that's the Excel default.
For some reason though when I open Excel, it defaults to Automatically Save on Tables, The Iteration box is checked, and the max Iteration is 1, which won't allow circular calcs. This is crazy!
Any Ideas?
Really bizarre thing here. Under Tools>Options>Calculation I keep checking the Automatic calculation, unchecking Iterations and making the max interations 100. I think that's the Excel default.
For some reason though when I open Excel, it defaults to Automatically Save on Tables, The Iteration box is checked, and the max Iteration is 1, which won't allow circular calcs. This is crazy!
Any Ideas?