Excel error with Bru'n water and "Add CaSO4... in sparging water" set to Yes

[GlowingApple]

I'm using Bru'n water 3.4. When I set "Add CaSO4 & CaCl2 to replace Chalk & Lime in Sparging Water?" to Yes, Excel gives me an error, "Excel cannot calculate a formula." and shows a circular reference: N14 (Finished SO4/Cl Ratio) points to G14 (overall water Chloride), which points to K20 (Sparge CaCl2 additions), which points back to N14 (Finished SO4/Cl Ratio). The sparge additions don't change at all.

I can't see the formulas (since I don't have the password to unprotect the sheet), so I'm not sure what's wrong, and don't know how to fix it. I have macros enabled, and everything else seems to be working, except for that box.

 

[mabrungard]

You need to go to: Excel Options and then the Formulas tab and then select: Enable Iterative Calculation. It should work then.