"Unable to set the installed property of the Add-in class" when opening a Microsoft® Excel® workpaper in CCH® ProSystem fx® Engagement or Workpaper Manager.

"Unable to set the installed property of the Add-in class" when opening a Microsoft® Excel® workpaper in CCH® ProSystem fx® Engagement or Workpaper Manager.

"Unable to set the installed property of the Add-in class" when opening a Microsoft® Excel® workpaper in CCH® ProSystem fx® Engagement or Workpaper Manager.

The following below are suggested resolutions for the error:  "Unable to set the installed property of the Add-in class" when opening a Microsoft® Excel® workpaper inside Engagement or Workpaper Manager.
 
  • The Epace addin has become disabled.  If so try and attempt to perform the following below:
  • Microsoft® Excel® 2013 and Higher:
  1. Open Microsoft® Excel® from outside of Engagement or Workpaper Manager.
  2. Click File
  3. Click Options
  4. Click Add-ins
  5. Make sure the Manage drop down menu shows Excel Add-ins
  6. Click Go.
  7. Locate the add-in labeled "Epace" and check the box next to it to make it active.
  8. Click OK through all remaining menu options and close Microsoft® Excel®.
  9. Open a Microsoft® Excel® workpaper inside the binder.

 

  • If still encountering the issue then it's possible a third party addin either in the Excel Addins or in the COM addins could be causing the issue.  Try disabling all other addins except for Epace in the Excel Addins & Pfx.Ribbon.ExcelAddin in the COM Addins.  We have identified also an erroneous entry in the Microsoft® Windows® registry. 
  1. Make sure to back up the Microsoft® Windows® registry and that you understand how to restore the registry if a problem occurs.
    • Warning! Modifying your system registry incorrectly can lead to Operating System corruption, possibly requiring reformatting and reinstalling the operating system.  It is suggested that your I.T. Administrator or support staff be consulted before modifying any registry entries.
  2. On the keyboard press Windows Key+R.
  3. Type Regedit.exe
  4. Press Enter.
  5. Browse to HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\##.0\Excel\resiliency\addinlist, where ## is the build number for the version of Microsoft Office that's installed.
    • Example Microsoft® Office 2013:  HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\15.0\Excel\resiliency\addinlist
    • Example Microsoft® Office 2016:  HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\16.0\Excel\resiliency\addinlist
  6. If the below addins are listed change the value from "1" to "2" for the following addins:
    • CWConnector.xll
    • epace.xla
    • ActiveData for Excel or ActiveDataAddinModule.
      • Please note CCH ActiveData is no longer supported with Wolters Kluwer and is advised to have this addin disabled.  Removing the addin from the Excel Addins in Microsoft® Excel® also should resolve the issue.
  7. Reboot the machine. 

 

  • If the installation of Microsoft® Excel® is local, then try a different Microsoft® Window® profile on the machine. If the new profile works fine with Engagement or Workpaper Manager, then you will need to recreate the original Microsoft® Window® profile.