Functions are missing or grayed out in Microsoft® Excel® for CCH® ProSystem fx® Engagement, Workpaper Manager, or Knowledge Coach.

The video below explains where to find the Microsoft® Excel*.xlb file so that it can be deleted. 

Over time, the file Excel*.xlb may need to be deleted. This is caused to the following: 
  • Missing or disabled Microsoft® Excel® functions on the Excel® toolbars.
  • Missing or disabled Microsoft® Excel® functions when right-clicking in a workbook.
  • Errors when launching Excel®
  • Errors when closing Excel®
To recreate a new Excel*.xlb file, perform the following below: 
  1. Close all Microsoft® Excel® workbooks.
  2. Close all Microsoft® Excel® files.
  3. Right-click on the Task Bar and select Task Manager.
  4. Click on the Processes or  Details tab and sort by Name.
  5. Right-click on any excel.exe processes and choose End Process.
  6. Press Windows+R on your keyboard to bring up the Run line.
  7. On the Run line, enter %appdata%\Microsoft\Excel, then press Enter.
  8. Delete all Excel*.xlb files.
    • Examples:
      • Excel12.xlb (Microsoft® Office 2007)
      • Excel14.xlb (Microsoft® Office 2010)
      • Excel15.xlb (Microsoft® Office 2013 / 2016 / 2019)
  9. When you open and close Microsoft® Excel®, the XLB file is recreated.  
If this issue is only occurring while using addin features for the trial balance in Engagement or Workpaper Manager, please follow the below article:
A third party program could be interfering with the loading behavior with the Engagement or Workpaper Manager addins.  
  1. Open Microsoft® Excel®.
  2. Click File
  3. Click Options.
  4. Click Addins.
  5. Under the Manage drop-down menu select Excel Addins and click Go.
  6. Uncheck all third party addins except for Epace.
  7. Repeat steps 2 through 4 and under Manage select COM Addins and click Go.
  8. Uncheck all third party addins except "Pfx.Ribbon.ExcelAddin"
    • If using Knowledge Coach, leave the Pfx.Ribbon.KnowledgeCoachExcelAddin enabled.
  9. Close Microsoft® Excel®
  10. Browse back to the directory and rename the Excel##.xlb file.
  11. Open a blank Microsoft® Excel® workbook and then close the program to regenerate a new Excel##.xlb file.
  12. Reopen a Microsoft® Excel® workbook in Engagement or Workpaper Manager.  
  13. If issue resolves, then troubleshoot each of the third party addins by individually by re-enabling them one by one, close and reopen Microsoft® Excel® to identify the possible culprit.
  Solution Tools
 Solution Id 000039154/sw886
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!