Engagement - PPC Add-Ins for Excel - Checking for disabled items
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
