"Runtime Error 13" and "Runtime error -2147483640" Excel 2011 Mac

Excel Help for "runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac in Excel Portfolio Optimization Template

"runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac

Rate this: (3/5 from 1 vote)

	Upon Openning the template I get the "Runtime Error 13 Type Mismatch" with the option to end. If I select end I get to the optimize page. After clicking "Optimize" the macro start to make the correlation Matrix, after the matrix is like 60% i get the  "Runtime error -2147483640 : Automation Error" After that the template stops and does nothing.  I Cannot use the template. Can Anyone Help??? Best Regards, Sterling
	Posted by stejimenez on 13 Jun 2014

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Portfolio optimization on Excel 2011 Mac Rate this: (4/5 from 2 votes) We just ran the portfolio optimization the latest version 14.4.2 of Excel 2011 for Mac without any problems. This runtime issue is likely to be due to the data used for optimization. If you can attach your template by replying to this post notification then we can investigate the issue.
	Excel Business Forums Administrator
	Posted by Excel Helper on 13 Jun 2014

Displaying page 1 of 1