How To Fix RSR_EXCEL_RUNTIME112 - Errors while deleting shapes in workbook

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 112

• Message text: Errors while deleting shapes in workbook

What causes this issue?

When 3.x workbooks are upgraded, the old shapes associated with the
<ZK>Documents</> and <ZK>Hierarchy</> nodes are deleted after the query
areas in the workbook are upgraded to the corresponding design items. An
error occurred while deleting these shapes.

System Response

Not all shapes in the workbook are deleted, but the workbook is
upgraded.

How to fix this error?

This problem can occur if the shapes in the workbook are protected, that
is, if the workbook or worksheet is protected. If the workbook or
worksheet is protected, it may not be possible to delete the shapes in
the workbook and an error therefore occurs.
If the remaining elements in the workbook are upgraded correctly and you
can refresh the workbook successfully, you can try deleting all the
remaining shapes manually in the worksheet and saving the workbook.

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_RUNTIME112 - Errors while deleting shapes in workbook ?

  The SAP error message RSR_EXCEL_RUNTIME112 typically occurs when there are issues related to Excel workbooks that are being used in conjunction with SAP BusinessObjects or SAP BW (Business Warehouse) reporting tools. This error often arises when users attempt to delete shapes or objects within an Excel workbook that has been generated or manipulated by SAP tools.
  Causes of RSR_EXCEL_RUNTIME112
  
  Corrupted Workbook: The Excel workbook may be corrupted or improperly formatted, leading to issues when trying to manipulate shapes or objects.
  Compatibility Issues: There may be compatibility issues between the version of Excel being used and the SAP tools or add-ins.
  Add-in Conflicts: Conflicts with other Excel add-ins or extensions that may interfere with the SAP functionalities.
  Insufficient Permissions: The user may not have the necessary permissions to modify the workbook or its contents.
  Excel Settings: Certain settings in Excel, such as macro settings or security settings, may prevent proper execution of SAP functions.
  
  Solutions to RSR_EXCEL_RUNTIME112
  
  
  Check for Corruption:
  
  Open the workbook in Excel and try to save it as a new file. This can sometimes resolve corruption issues.
  If the workbook is still problematic, consider recreating it from scratch.
  
  
  
  Update Software:
  
  Ensure that both SAP and Excel are updated to the latest versions. Compatibility issues can often be resolved with updates.
  Check for updates to any SAP add-ins or plugins that are being used with Excel.
  
  
  
  Disable Conflicting Add-ins:
  
  Temporarily disable other Excel add-ins to see if the error persists. You can do this by going to File > Options > Add-ins and managing the add-ins from there.
  
  
  
  Check Permissions:
  
  Verify that you have the necessary permissions to modify the workbook. If you are working in a shared environment, consult with your administrator.
  
  
  
  Adjust Excel Settings:
  
  Check the macro settings in Excel. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and ensure that macros are enabled if required.
  Review any security settings that may be preventing the execution of SAP functions.
  
  
  
  Recreate the Workbook:
  
  If the issue persists, consider recreating the workbook from scratch, ensuring that you follow the correct procedures for integrating SAP data.
  
  
  
  Related Information
  
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes or patches that address this specific error.
  Documentation: Review the documentation for the specific SAP tool you are using (e.g., SAP BW, SAP BusinessObjects) for any known issues or troubleshooting steps.
  Community Forums: Engage with SAP community forums or user groups where similar issues may have been discussed, and solutions shared.
  
  If the problem continues after trying these solutions, it may be beneficial to contact SAP support for further assistance, providing them with detailed information about the error and the context in which it occurs.