Pool Water Chemistry (Warning: Can Get Technical)

[jereece]

I am using Office 2003, the latest version. I have all the addins turned on, including "Solver Add-In" and still get this error.

[chem geek]

I am using Office 2003, the latest version. I have all the addins turned on, including "Solver Add-In" and still get this error.

I'm sorry you are having trouble getting it to work. I created it on a Mac in Microsoft Excel 2004 for Mac Version 11.2.5 (060620) and I also tried it on a PC that has Microsoft Excel 2000 (9.0.6926 SP-3) running Windows 2000 Professional. It worked for me on the PC though I had to add the Solver Add-In and I also had to change the security level to Medium and accept the warning about macros running.

[EDIT]I have been very frustrated with trying to get Solver to work consistently when running from a macro on the PC. So, I'm going to delete my later posts that tried to explain workarounds since they are a pain and may not work. Instead, I'm going to try to rewrite the macro to do the Solver function myself. I've only got two "goals" with two "variables" so that shouldn't be too hard to do with a 2-variable partial differentiation (Newton-Raphson) approach. I hope that doesn't end up being as hard as it sounds![END-EDIT]

[SECOND-EDIT] Since around 8/23/06 (see later posts) Solver is no longer used. [END-EDIT]

Richard