Home > Forum Home > Excel Portfolio Optimization Template > run time error 1004 Share

Run time error 1004

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


Forum TopicPost Reply Login

Run Time Error 1004

Rate this:
(2.5/5 from 2 votes)
Confusedi keep getting a runtime error 1004.  "unable to get the Corrle property of the worksheetfunction class".   why is this happening?
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most recent | Chronological | Highest Rated
Confused
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 on
Oops
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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for run time error 1004 in the