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

  • Show details Hide details
  • 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

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker