![]() |
Solver slow
I have a large workbook that includes a macro that first sets calculation
mode to manual and then starts the Solver. All data and calculations used by the Solver are located in a single worksheet. It is really slow. It is like if the Solver is doing an "Application.Calculate" at each iteration, calculating all worksheets, which would make sense. - Am I right thinking that the Solver use "Application.Calculate"? - If yes, is it possible to specify to the Solver to calculate only a given worksheet? Thanks. |
All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com