How To Fix PE587 - Version of Microsoft Excel macro cannot be identified

SAP Error Message - Details

• Message type: E = Error

• Message class: PE - Shift Planning: Messages

• Message number: 587

• Message text: Version of Microsoft Excel macro cannot be identified

What causes this issue?

The system tried to identify the version of the Microsoft Excel macro
used for printing shift plans. The macro could not be found.

System Response

Version check and print operation have been cancelled.

How to fix this error?

Contact the person responsible for SAP frontend installation in your
company. Have them check if the HR: Microsoft Excel Link" component was
installed during frontend installation. If this is not the case, then
the component must be installed now.
Note: If the component is installed, you will find files that begin
with "WDPDDMAC" in the SAP frontend software directory (not in the
working directory).

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message PE587 - Version of Microsoft Excel macro cannot be identified ?

  The SAP error message PE587, which states "Version of Microsoft Excel macro cannot be identified," typically occurs when there is an issue with the integration between SAP and Microsoft Excel, particularly when using SAP's Excel-based tools like SAP Analysis for Office or SAP BusinessObjects.
  Causes:
  
  Incompatible Versions: The version of the Excel macro or the SAP add-in may not be compatible with the version of Microsoft Excel you are using.
  Missing or Corrupted Files: The required Excel macro files may be missing or corrupted.
  Incorrect Installation: The SAP add-in for Excel may not be installed correctly or may be outdated.
  Security Settings: Excel's macro security settings may be preventing the macro from running.
  File Format Issues: The file format of the Excel workbook may not be supported or recognized by the SAP system.
  
  Solutions:
  
  Check Compatibility: Ensure that the versions of SAP and Microsoft Excel you are using are compatible. Refer to SAP's documentation for the supported versions.
  Reinstall SAP Add-in: Uninstall and then reinstall the SAP add-in for Excel to ensure that it is correctly installed and up to date.
  Update Excel: Make sure that you are using the latest version of Microsoft Excel. Check for updates and install them if available.
  Check Macro Security Settings:
  
  Open Excel.
  Go to File > Options > Trust Center > Trust Center Settings.
  Under Macro Settings, ensure that macros are enabled (you may choose "Enable all macros" for testing, but be cautious with this setting).
  
  
  Repair Office Installation: If the issue persists, consider repairing your Microsoft Office installation through the Control Panel.
  Check File Format: Ensure that the Excel file is saved in a compatible format (e.g., .xlsm for macro-enabled files).
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific patches or updates related to the error message PE587.
  Documentation: Refer to the official SAP documentation for Analysis for Office or BusinessObjects for detailed guidance on installation and configuration.
  Community Forums: Engage with SAP community forums or support channels for additional insights and solutions from other users who may have encountered the same issue.
  
  If the problem persists after trying these solutions, it may be beneficial to contact SAP support for further assistance.