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. |
All times are GMT +1. The time now is 05:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com