How To Fix RSR_EXCEL_RUNTIME121 - Errors while calling macro during refresh

RSR_EXCEL_RUNTIME121 - Overview

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 121

• Message text: Errors while calling macro during refresh

What causes this issue?

Errors occurred while calling the specified macro when the workbook was
refreshed.

System Response

The BEx Analyzer tries to call the macro and returns a warning that the
macro could not be called due to unknown issues.

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.
3. Check whether the macro compiles successfully.

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.

RSR_EXCEL_RUNTIME121 - Details

• The SAP error message RSR_EXCEL_RUNTIME121 typically occurs when there is an issue with executing a macro in Excel while refreshing data from SAP BW (Business Warehouse). This error can arise due to various reasons, including issues with the Excel environment, the macro itself, or the connection between Excel and SAP.
  Causes of RSR_EXCEL_RUNTIME121 Error
  
  Macro Issues: The macro being called may have errors or may not be properly defined.
  Excel Environment: There may be issues with the Excel installation, such as missing components or corrupted files.
  Security Settings: Excel's macro security settings may be preventing the macro from running.
  SAP BW Connection: There may be issues with the connection between Excel and SAP BW, such as incorrect credentials or network issues.
  Excel Version Compatibility: The version of Excel being used may not be compatible with the SAP BW add-in or the macro.
  Add-in Issues: The SAP BW Excel add-in may not be properly installed or configured.
  
  Solutions to