fboehlandt
Active Member
- Joined
- Sep 9, 2008
- Messages
- 334
Hello everyone,
I deactivated automatic calculation in my workbook due to the large number of operations. Solver obviously needs to be able to recalculate results to arrive at the optimal solution. It seems though as if Solver recalculates the entire workbook instead of the worksheet only. I tried to run the optimization in a new workbook but to no avail (I need to keep the old workbook open). Is there a way to either:
- prompt Solver to refresh a worksheet only
- or to keep one workbook from being recalculated (even if prompted by what-if analysis) whilst allowing another to refresh?
Since I need to copy the Solver results back to the original workbook and I have written a procedure that runs approx. 1000 optimizations (Solver VBA), I cannot close and re-open the original workbook every time. Under normal circumstances, each optimization should take no longer than a fraction of a second. But because of the re-calc times, the optimization runs for up to 20 secs per problem. Any advice is greatly appreciated
Regards
I deactivated automatic calculation in my workbook due to the large number of operations. Solver obviously needs to be able to recalculate results to arrive at the optimal solution. It seems though as if Solver recalculates the entire workbook instead of the worksheet only. I tried to run the optimization in a new workbook but to no avail (I need to keep the old workbook open). Is there a way to either:
- prompt Solver to refresh a worksheet only
- or to keep one workbook from being recalculated (even if prompted by what-if analysis) whilst allowing another to refresh?
Since I need to copy the Solver results back to the original workbook and I have written a procedure that runs approx. 1000 optimizations (Solver VBA), I cannot close and re-open the original workbook every time. Under normal circumstances, each optimization should take no longer than a fraction of a second. But because of the re-calc times, the optimization runs for up to 20 secs per problem. Any advice is greatly appreciated
Regards