troubleshooting

Problem 

The most common problem is getting the macro to run for the first time. If you are having this problem, its likely that the Solver function is not installed correctly. Some typical symptoms of this problem include:  1) Nothing happens when you press Alt, t, v 2) You get this error when you press the 'Fit Curve' button: Compile error: Cannot find project library 3) You cannot find the Solver in the Tools pull-down menu  

Suggestions 

First try opening the Visual Basic editor (Alt+F11) or Tools, Macro, Visual Basic Editor.  Then in the editor, go to Tools, References. Here you should see a list of  check boxes of Available References. SOLVER should be checked off. There might be something  labeled SOLVER Missing or something like that. In that case, you'll need to uncheck that before  checking the SOLVER. If neither of those are there then try going back to the Excel spreadsheet and  go to Tools, Add-Ins. There you should select Solver Add-In. You may need to have the  Analysis Toolpak - VBA checked off too, but not sure. Basically, you want to make sure that the  Solver add-in is installed. There are probably better instructions for going about this on the web.  Anyway, try some of these and let me know if you can get it working. If not, I might be able to  diagnose the problem based on what you found. You may even need to find your MS Excel or  Office disks to actually install the Solver (the default settings sometimes don't include this  when installing MS Office).