Home → Troubleshooting → @RISK for Excel: Other Issues → #NAME Errors in Place of Capital IQ Functions
Applies to:
@RISK 6.0.0 through 6.2.0
Problem:
When I run @RISK and Capital IQ together, my CIQ functions show as #NAME errors.
Or, when I open Excel, one of these errors pops up:
'/A .xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.
'C:\Users\...\Microsoft\AddIns\ciqfunctions.udf"' could not be found. Check the spelling of the file name, and verify that the file location is correct.
(The file location in the second message will vary.)
Is @RISK incompatible with Capital IQ?
Response:
@RISK 6, through release 6.2.0, unfortunately was incompatible with Capital IQ. In some instances there were even Excel crashes when both add-ins were loaded together. The recent release of @RISK 6.2.1 fixed those problems, so your best bet is to upgrade your copy of @RISK or The DecisionTools Suite.
We are grateful to the people at S&P Capital IQ for their help in finding the problem, and for confirming that the new release of @RISK fixed it.
last edited: 2014-04-04