Excel Solver giving wrong optimal solution

Hello,

I have this little problem that s been taking all my time.
I developed a program with vba that uses solver using excel 2007. Now I need to open the file with older version of excel. The thing is when I run the button solver does not excute and cells are not updated. I tried to solve it by going to solver in TOOLS and it works fine, however when I assign the solver macro code to the button it doesnt do anything.
Please help!

Thank You,

Bump
Hello,

I have this little problem that s been taking all my time. I am reposting this with additional clarifications
I developed a program with vba that uses solver using excel 2007 (in Windows Vista). Now I need to open the file with older version of excel (In windows XP). The thing is when I run the button, solver does not excute and cells are not updated. I tried to solve it by going to solver in TOOLS and it works fine, however when I assign the solver macro code to the button it doesnt do anything.
I noticed that when I run the button and excution is over, I go to solver from the TOOLS menu and I can only see the constraints entered, but not the obejctive cell and the changing cells.
Please help! any suggstion would be great!!

Thank You,

Hello,

This is not my first tim with excel solver in VBA. I built a spreadsheet where user can determine optimal ordering quantities to minimize total cost.
My cost function can not be evaluated at 0.
I only have two constraints which actually do allow my optimal result to be at 0, but since my function can not be evaluated at 0, I expect a diffrent answer.

Now sometimes I obtain an optimal 0 solution, but total cost can not calcultated. I then change the optimal result cell from 0 to any random number, and I solve again, and it gives the expected optimal solution.

what could be wrong??

Thank You,