HomeTroubleshooting@RISK for Excel: Other Issues#NAME Errors in Place of Capital IQ Functions

8.5. #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

This page was: Helpful | Not Helpful