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

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 06 Feb 2015

Replies - Displaying 1 to 3 of 3

Order Replies By: Most Recent | Chronological | Highest Rated

	Optimization locking computer 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 Excel Helper on 06 Feb 2015

	file attached Rate this: (3/5 from 1 vote) i think the sheet is attached. thanks for the help
	Posted by adam on 06 Feb 2015

	Version of the portfolio optimization template Rate this: (4/5 from 2 votes) 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 Excel Helper on 06 Feb 2015

Displaying page 1 of 1