+ Reply to Thread
Results 1 to 5 of 5

Excel Solver giving wrong optimal solution

  1. #1
    Registered User
    Join Date
    03-26-2008
    Posts
    44

    solver/vba

    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,

  2. #2
    Registered User
    Join Date
    03-26-2008
    Posts
    44

    Unhappy Excel solver does not run with button

    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. 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.
    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,
    Last edited by gtg430i; 03-28-2008 at 01:18 PM.

  3. #3
    Registered User
    Join Date
    03-26-2008
    Posts
    44

    Solver does not excute when assigned to button

    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,
    Last edited by gtg430i; 03-28-2008 at 04:14 PM.

  4. #4
    Registered User
    Join Date
    03-26-2008
    Posts
    44

    Solver does not execute when code assigned to button

    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,

  5. #5
    Registered User
    Join Date
    03-26-2008
    Posts
    44

    Excel Solver giving wrong optimal solution

    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,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1