Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeated calls to Solver.xla causing Excel problems
A model I have created that runs solver on several data sets is causing two
issues. The workobook is designed to use the same solver setup over and over. A single cell's value controls what base data is fed into solver, and the code loops through up to 6 values for that single cell, and each loop requires. Within each loop there are 2 calls to solver, each call using a different set of interest rates. Problem #1 - Can't ACTIVATE correct workbook - Excel 2003 After each loop, the solver results sheet (including 3 graphs) is copied to a separate workbook and everything on it is converted to values and pictures. The first time the model is run this appears to work just fine through all 6 loops. The second (or third) time the model is run, Excel will sometimes refuse to (re)activate the workbook that contains the solver model. I have stopped the code at that point and, while I can interactively toggle between open workbooks, VBA commands to activate the solver workbook fail. It seems to fail in different loops, and it sometimes runs fine for 2 or 3 complete models and then fails. Has anybody seen anything like this? Problem #2 - It runs SLLOOOOWWLY in 2007 and quickly in Excel 2003 This is more of an observation/complaint/bug report than a request for help On a 5 year old XP Pro box with XL2003, it took about 2 minutes to run one complete set of 4 loops. That box has a P4 2.4Ghz processor and 1 gig RAM. On a very similar box with XP Pro/XL2007 the same model took nearly 40 minutes. On a brand new PC with a reasonably fast Core Duo, Vista Ultimate, 2 gigs RAM and xl2007, the same test took around 20 minutes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rand () causing Problems. | Excel Discussion (Misc queries) | |||
Excel 2000 Solver Problems | Excel Programming | |||
Addins causing problems | Excel Programming | |||
Is Excel causing me system problems? | Excel Discussion (Misc queries) | |||
Repeated application of Solver to new equations | Excel Programming |