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 TopicPost Reply Login

When Running Scenarios The Sheet Locks Up And Wont Complete The 12100 Total

Rate this:
(3/5 from 1 vote)
Confused when i run the optimization, it locks up (my whole computer) at about 9400 computations while trying to get to 12100??
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
Depending on the version of Excel, the progress bar can freeze during parts of the optimization but this should not lock the entire system.

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 on
Confused
Rate this:
(3/5 from 1 vote)
i think the sheet is attached. thanks for the help
 Posted by on
Confused You'll need to attach the template to the actual email by replying to the post notification email.

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 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