KSM IT

317-580-2008
Login Sign up

Engagement - PPC Add-Ins for Excel - Checking for disabled items

Modified on: Wed, Aug 30 2023 10:08 AM

Excel Engagement/PPC Add-Ins - Checking for disabled items


ISSUE: If when you open Excel workpapers from Engagement and any of the following things happen:

  • Incorrect file names
  • No Engagement tab in the Ribbon
  • TB link functions not functioning properly
  • Rolled forward lead sheets showing PY
  • PPC WPs with macros not appearing "Macros must be enabled in order to use this workbook"


SOLUTION: Follow the steps below to resolve these issues


**NOTE**: You can also use the AppChecker to check these for you here: Engagement Tab Not Showing In Excel : KSM IT 

  • Close all open Microsoft applications
  • Open Microsoft Excel outside of Engagement
  • Select File in the Ribbon > Options > Add-ins
  • At the bottom next to Manage select the drop-down arrow, select Disabled Items, and select Go



  • If anything is listed select it and select Enable, then Close
  • Under the Manage dropdown, select the drop-down arrow and select COM Add-ins
  • Click on Go
  • Confirm that the relevant add-ins from the list below are selected

 

Excel COM Add-Ins

-  Pfx.Ribbon.ExcelAddin

-  PPCExcel12

-  PPCExcel12Repurpose



 

  • Go back into the Add-Ins via File > Options > Add-ins
  • Under the Manage option, select Excel Add-ins
  • Select Go and be sure the following add-in is there and checked, nothing else should be checked

 

Excel Add-ins

-  Epace.xla

  • Select OK > Close the program > Re-open the program





Was this answer helpful?