☰

Excel 2010 - 嘗試尋找新增至總計中的子集時停止求解器

tag-icon • tag-icon microsoft-excel microsoft-excel-2010
Excel 2010 - 嘗試尋找新增至總計中的子集時停止求解器

我發現瞭如何使用求解器來找到添加到給定總數的數字子集 - 非常好。

現在，我有時不確定是否有解決方案。當 Excel 花費太長時間時，有沒有辦法在求解器運行完每個可能的迭代之前停止它？由於數位集相對較小 (25)，求解器現已運行了 20 分鐘以上。否則，即使在真正進行計算時，Excel 也不會出現速度變慢的問題。

有任何想法嗎？

答案1

有任何想法嗎？

您嘗試過點擊ESC嗎？

看一眼 ”Excel 求解器 - 暫停或停止求解器“ 請：

If you press ESC while Solver is solving, the Show Trial Solution dialog box appears.  Do one of the following:

    Click Stop to stop the solution process.  TheSolver Results dialog appears with a message that Solver stopped at your request.
    Click Continue to allow Solver to continue solving until you press ESC again, a Solving Limit is reached, or a solution is found.

If Solver reaches one of the Solving Limits (Max Time, Iterations, Max Subproblems or Max Feasible Solutions) while solving a problem, the Show Trial Solution dialog box appears.  Do one of the following:

    Click Stop to stop the solution process.  The Solver Results dialog appears with a message that the limit was reached.
    Click Continue to allow Solver to continue solving without the limit mentioned in the dialog box message.  If another limit is reached, the Show Trial Solutiondialog box will re-appear, once for each limit.

相關內容