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
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
keep value from last update and don't ask to update links jh3016 Excel Discussion (Misc queries) 3 July 25th 05 01:37 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 07:18 PM.

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"