Solver not working in Excel 2007
 

I have a macro using Solver that works perfectly in Excel 2003 but does not
work in Excel 2007. I believe I have installed the addin and set up the
references correctly to solver.xlam (after some hassle) as I get no error
messages now when I try to run the macro. The macro seems to run, it just
doesn't solve the equation. Can anyone give me some ideas on how to fix or
troubleshoot this? thanks.