LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Solver Update Issue

Hello,

I am using Solver to do a sourcing problem. I have 5 plants and 5
locations to ship to. Production costs are different at each plant and
there is a shipping cost. Also, there is a min. capacity that each
location can run. That is the background.

Anyway, I am having trouble with solver updating. I can run it the
first time and I get an answer. I can then change one value, such as
increasing the min. capacity, and solver will recalculate fine. When
I try to go back to the original capacity solver's answer doesn't
change. From that point it doesn't seem to matter what I do, solver's
answer never changes. I am solving for a min. sum of values. I can
change all values to zero, thus a cost of zero, and I run solver and
get an answer of zero which totally ignores that constraint that I
have in it for a required min. capacity.

Bottom line: Solver doesn't seem to update with new information I put
in. I know all of my constraints are right (because it worked the
first time). Thanks in advance for any help.

David

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver Update Issue DtTall Excel Discussion (Misc queries) 1 March 13th 07 01:49 PM
i want to update one excel file the other one update automaticaly Basant New Users to Excel 1 December 16th 06 12:50 AM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Excel Solver Issue nakedbamboo Excel Discussion (Misc queries) 5 November 14th 05 01:26 AM
Update / don't update dialog box Tim Kredlo Excel Worksheet Functions 1 November 11th 04 04:25 PM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"