ISSUE:

Error message when opening Microsoft Excel. 

"Macros must be enabled in order to use this workbook" when opening a PPC Checkpoint Tools workpaper within CCH ProSystem fx Engagement.

SOLUTION:

• In Excel, select File > Options
• Select Trust Center > Trust Center Settings
• Select Macro Settings
• Select Enable VBA Macros
• Select Trust access to the VBA project object model
  
  
  
  
• You must ALSO add the PPC and Engagement path to the Microsoft Office Trusted Locations.
  • Open a Microsoft Excel workbook and click File > Options > Trust Center > Trust Center Settings.
  • This is to trust the Engagement location
    • Click Trusted Locations > Add New location.
    • In the Path box, enter C:\Pfx Engagement\WM\Workpapers\.
    • Select the check box Subfolders of this location are also trusted.
    • Click OK.
  • This is to trust the PPC location
    • Click Trusted Locations > Add New location.
    • In the Path box, enter C:\Program Files (x86)\Common Files\PPC\.
    • Select the check box Subfolders of this location are also trusted.
    • Click OK.
      
      
  • Select the check box "Allow Trusted Locations on my network (not recommended)."  
  • Note: While the option is listed as not recommended, if you are working with Microsoft Excel workbooks that originated on a network location or are linked from a network location, this option is required for functionality.
  • Close Excel
  • Proceed with opening the desired workpaper

FINAL SOLUTION:

• Remove the Excel template file
  • Delete C:\Users\tmiller\AppData\Roaming\Microsoft\Excel\Excel15.xlb
  • Delete all folders/files except XLSTART from C:\Users\tmiller\AppData\Roaming\Microsoft\Excel
    
    
• Windows key > type appwiz.cpl > locate both of the following applications and repair them (versions should match)
  
  
  
• Check WP again. Typically 2500 and 3201