How To Fix RSR_EXCEL_RUNTIME121 - Errors while calling macro during refresh

SAP Error Message - Details

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_EXCEL_RUNTIME121 - Errors while calling macro during refresh ?

  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 RSR_EXCEL_RUNTIME121 Error
  
  
  Check the Macro:
  
  Review the macro code for any errors or issues.
  Ensure that the macro is properly defined and does not contain any syntax errors.
  
  
  
  Excel Security Settings:
  
  Go to Excel Options > Trust Center > Trust Center Settings > Macro Settings.
  Ensure that macros are enabled and that the settings allow for the execution of the macro.
  
  
  
  Repair Excel Installation:
  
  If you suspect that the Excel installation is corrupted, consider repairing it through the Control Panel.
  
  
  
  Check SAP BW Connection:
  
  Verify that the connection to SAP BW is correctly configured and that you have the necessary permissions.
  Test the connection to ensure it is working properly.
  
  
  
  Update Excel and SAP Add-in:
  
  Ensure that you are using a compatible version of Excel with the SAP BW add-in.
  Check for updates for both Excel and the SAP BW add-in and install any available updates.
  
  
  
  Reinstall SAP BW Add-in:
  
  If the add-in is not functioning correctly, consider uninstalling and then reinstalling the SAP BW Excel add-in.
  
  
  
  Check for Conflicting Add-ins:
  
  Disable any other Excel add-ins that may be conflicting with the SAP BW add-in.
  
  
  
  Run Excel as Administrator:
  
  Sometimes running Excel with elevated privileges can resolve permission-related issues.
  
  
  
  Related Information
  
  SAP Notes: Check SAP Notes for any specific patches or updates related to the RSR_EXCEL_RUNTIME121 error.
  Excel Logs: Review any logs generated by Excel or the SAP add-in for more detailed error messages.
  Community Forums: Consider searching or posting in SAP community forums for additional insights from other users who may have encountered the same issue.
  
  If the problem persists after trying these solutions, it may be beneficial to contact your IT support team or SAP support for further assistance.