GlowingApple
Well-Known Member
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.
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.