How To Fix RSR_EXCEL_RUNTIME119 - Errors during refresh; specified macro &1 not found in workbook

RSR_EXCEL_RUNTIME119 - Overview

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 119

• Message text: Errors during refresh; specified macro &1 not found in workbook

What causes this issue?

The workbook does not contain macro &V1&. The workbook property
specifies a macro that is to be called when the workbook is refreshed.
However, the workbook does not contain the specified macro.

System Response

The BEx Analyzer tries to call the macro and returns a warning that the
macro is not found.

How to fix this error?

1. Check whether the workbook contains the macro specified in the
workbook properties.
2. If the workbook does not contain the macro, add the macro with the
relevant signature or remove the macro name from the workbook
properties.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_EXCEL_RUNTIME119 - Errors during refresh; specified macro &1 not found in workbook ?

  The SAP error message RSR_EXCEL_RUNTIME119 indicates that there is an issue with a macro that is expected to be found in an Excel workbook but is not present. This error typically occurs when you are trying to refresh a report in SAP Analysis for Microsoft Office (AO) that relies on a specific macro to function correctly.
  
  Cause:
  
  Missing Macro: The specified macro (denoted as &1 in the error message) is not present in the Excel workbook. This could happen if the workbook was modified or if the macro was deleted or not included in the version of the workbook you are using.
  Incorrect Workbook: You might be using the wrong workbook that does not contain the necessary macros.
  Macro Security Settings: Excel's macro security settings may be preventing the macro from running, which can lead to this error.
  Version Compatibility: There may be compatibility issues between the version of SAP Analysis for Office and the