Run time error 1004

Excel Help for Run Time Error 1004 in Excel Portfolio Optimization Template

Run Time Error 1004

Rate this: (2.5/5 from 2 votes)

	i keep getting a runtime error 1004.  "unable to get the Corrle property of the worksheetfunction class".   why is this happening?
	Posted by adam on 26 Mar 2013

Replies - Displaying 1 to 2 of 2

Order Replies By: Most Recent | Chronological | Highest Rated

	Excel version and language Rate this: (3.7/5 from 3 votes) The correlation matrix is constructed by using the CORREL function in Excel.  This error could be due to this functin not being available in the version of Excel that you are running.  Which version of Excel and regaional language are you using?
	Excel Business Forums Administrator
	Posted by Excel Helper on 26 Mar 2013

	run time error 1004 Rate this: (3/5 from 1 vote) Troubleshooting StepsStart Microsoft Excel.On the Menu Bar select "File" > "[Excel] Options" > "Trust Center" > "Trust Center Settings..." > "Macro Settings"In the top section, select the radio button for "Disable all macros with notification" Regards,Rachel Gomez
	rachel
	Posted by RachelGomez161999 on 03 Jan 2023

Displaying page 1 of 1