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

PE587 - Overview

• 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