| Home > Forum Home > Excel Portfolio Optimization Template > when running scenarios the sheet locks up and wont complete the 12100 total | Share |
When running scenarios the sheet locks up and wont complete the 12100 total
Excel Help for When Running Scenarios The Sheet Locks Up And Wont Complete The 12100 Total in Excel Portfolio Optimization Template
| Forum Topic | Post Reply Login |
When Running Scenarios The Sheet Locks Up And Wont Complete The 12100 Total | Rate this: (3/5 from 1 vote) |
 | when i run the optimization, it locks up (my whole computer) at about 9400 computations while trying to get to 12100?? | |
| Posted by adam on | ||
| Replies - Displaying 1 to 3 of 3 | Order Replies By: Most Recent | Chronological | Highest Rated |
 | Rate this: (3/5 from 1 vote) If the process does not end when leaving it to finish, then please advise on the version of Excel and number of assets for optimization. You can also attach you template to a reply to this forum post notification so that we can investigate. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Rate this: (3/5 from 1 vote) |
| Posted by adam on |
| Rate this: (4/5 from 2 votes) However, when you refer to 9400, computations it seems that you may be using an outdated version of the template. The latest version does not have the notion of iterations (computations) as it uses a folding convergence algorithm for optimization which is also much faster. You can download this from here. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for when running scenarios the sheet locks up and wont complete the 12100 total in the Excel Business Solutions Directory |