Palisade Knowledge Base

Home → Troubleshooting → All Products: Startup → "Unable to set the installed property ..."

2.96. "Unable to set the installed property ..."

Applies To:
@RISK 4.5 for Excel (not including @RISK 4.5.7)
@RISK for Project 4.1.4
@RISK 4.0 for Excel
Evolver
RISKOptimizer

Problem:
@RISK (Evolver, RISKOptimizer) will not start and returns the error message:

Runtime error 1004: Unable to set the installed property of the add-in class.

or

Runtime error 1004: Unable to get the add property of the add-in class.

(Please contact Technical Support if the message is "That function is not valid".)

Response:
This error message can occur for a couple of different reasons. Here are possible causes and cures.

Reason 1: The Dtools32 add-in, which is used by @RISK, has not been properly added to the Excel Add-In collection.

To begin, get into Excel's Add-Ins dialog. This is in different places in different versions of Excel, as follows:

  • Excel 2003 and below: In the menu, click Tools » Add-ins.
  • Excel 2007 (if you are running @RISK for Project 4.1.4r2 or r3): Click the round Office button, then Excel Options » Add-Ins. At the bottom of the right-hand panel, select Excel add-ins and click Go.
  • Excel 2010 (if you are running @RISK for Project 4.1.4r3): Click File » Options » Add-Ins. At the bottom of the right-hand panel, select Excel add-ins and click Go.

After opening Excel's Add-Ins dialog:

  • If Dtools32 is listed but not checked, check it, and then exit Excel.

  • If Dtools32 does not appear in the Add-Ins dialog:

    1. Click the Browse button in the Add-Ins dialog. Use the Browse dialog to navigate to the folder path C:\Program Files (x86)\Palisade\SYSTEM, C:\Program Files\Palisade\SYSTEM, or C:\DTOOLS\SYSTEM, whichever one exists.
    2. Select Dtools32.xll and click the OK button.
    3. Dtools32 should now appear in the Add-Ins dialog with a check mark in the adjacent box. Click OK.
    4. Exit Excel.

  • If Dtools32 is checked:

    1. Remove the check mark beside Dtools32.
    2. Close Excel completely.
    3. Reopen Excel by itself, without attempting to open @RISK.
    4. Get back into the Add-Ins dialog; see above for instructions for your version of Excel.
    5. Click the Browse button in the Add-Ins dialog. Use the Browse dialog to navigate to the folder path C:\Program Files (x86)\Palisade\SYSTEM, C:\Program Files\Palisade\SYSTEM, or C:\DTOOLS\SYSTEM, whichever one exists.
    6. Select Dtools32.xll and click the OK button. You will probably get the message: "A file named Dtools32 already exists in this location. Would you like to replace it?" Select Yes.
    7. Exit Excel.

Launch @RISK. The error message should now be eliminated.

Reason 2: "Trust all installed add-ins and templates" has been turned off in the Macro Security settings.

The following procedure should resolve the error:

  • If you have Excel 2003 or below:

    1. Start Excel and select Tools > Macro > Security from the menu.
    2. Make the Trusted Publishers tab active.
    3. Check the box labeled "Trust all installed add-ins and templates" then hit OK.
    4. Exit Excel.

  • If you have Excel 2007 with @RISK for Project 4.1.4r2 or r3, or Excel 2010 with @RISK for Project 4.1.4r3, see Excel Macro Security settings.

Now the appropriate Palisade add-in should load without incident.

last edited: 2013-02-27

This page was: Helpful | Not Helpful