How To Fix RSR_EXCEL_RUNTIME120 - Errors during refresh; specified macro &1 does not have correct signature

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 120

• Message text: Errors during refresh; specified macro &1 does not have correct signature

What causes this issue?

Macro &V1& does not have the correct signature. The workbook property
specifies a macro that is to be called when the workbook is refreshed.
However, the specified macro has a different signature to the one
specified in the BEx Analyzer documentation.

System Response

The BEx Analyzer tries to call the macro and returns a warning that the
macro has an incorrect signature.

How to fix this error?

1. Check whether the workbook contains the macro specified in the
workbook properties.
2. If the workbook contains the macro, correct the signature of the
macro to the correct parameters as specified in the BEx Analyzer
documentation or remove the macro name from the workbook properties.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_EXCEL_RUNTIME120 - Errors during refresh; specified macro &1 does not have correct signature ?

  The SAP error message RSR_EXCEL_RUNTIME120 indicates that there is an issue with a macro in an Excel workbook that is being used in conjunction with SAP Business Explorer (BEx) or SAP Analysis for Office. The specific error message states that the specified macro does not have the correct signature, which typically means that the macro is either missing, not properly defined, or has been altered in a way that makes it incompatible with the expected parameters.
  Causes:
  
  Macro Signature Mismatch: The macro in the Excel file does not match the expected signature (parameters, return type, etc.) that SAP is trying to call.
  Corrupted Macro: The macro may be corrupted or not functioning correctly.
  Version Compatibility: The version of the Excel file or the SAP Analysis for Office add-in may not be compatible with the macro.
  Missing Macro: The macro may not be present in the Excel file, or it may have been deleted or renamed.
  Security Settings: Excel's macro security settings may be preventing the macro from running.
  
  Solutions:
  
  Check Macro Signature: Verify that the macro in the Excel file has the correct signature as expected by SAP. This may involve checking the parameters and return types.
  Recreate or Repair the Macro: If the macro is corrupted, try recreating it or repairing it to ensure it functions correctly.
  Update SAP Analysis for Office: Ensure that you are using the latest version of SAP Analysis for Office, as updates may include fixes for compatibility issues.
  Check Excel Security Settings: Go to Excel Options > Trust Center > Trust Center Settings > Macro Settings, and ensure that macros are enabled. You may need to adjust the settings to allow the macro to run.
  Test with a Different Workbook: Try using a different Excel workbook with a known working macro to see if the issue persists. This can help isolate whether the problem is with the specific workbook or a broader issue.
  Consult Documentation: Refer to SAP documentation or support resources for any specific requirements or known issues related to the macro you are using.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to the error message RSR_EXCEL_RUNTIME120.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Documentation: Review the documentation for SAP Analysis for Office and any relevant BEx documentation for guidance on macros and their expected signatures.
  
  If the issue persists after trying the above solutions, consider reaching out to your SAP support team for further assistance.