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

SAP Error Message - Details

• 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 version of Excel you are using.
  
  Solution:
  
  Check for the Macro: Open the Excel workbook and check if the specified macro exists. You can do this by going to the "Developer" tab in Excel and selecting "Macros." If the macro is missing, you may need to restore it from a backup or obtain a version of the workbook that includes it.
  Recreate the Macro: If the macro is missing and you have the logic or code for it, you can recreate the macro in the workbook.
  Verify Workbook: Ensure that you are using the correct workbook that is intended for the report you are trying to refresh.
  Adjust Macro Security Settings: Go to Excel Options > Trust Center > Trust Center Settings > Macro Settings, and adjust the settings to enable macros. You may need to select "Enable all macros" (not recommended for security reasons) or "Disable all macros with notification" to allow you to enable them when needed.
  Check Compatibility: Ensure that your version of SAP Analysis for Office is compatible with your version of Excel. If there are known issues, consider updating either SAP AO or Excel to a compatible version.
  Consult Documentation: Refer to the SAP documentation or support resources for any specific requirements or known issues related to the macros used in your reports.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to the error message RSR_EXCEL_RUNTIME119.
  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 SAP Analysis for Office documentation for guidelines on using macros and troubleshooting common issues.
  
  By following these steps, you should be able to resolve the RSR_EXCEL_RUNTIME119 error and successfully refresh your report in SAP Analysis for Office.