How To Fix RSR_EXCEL_RUNTIME105 - Errors while upgrading workbook properties

RSR_EXCEL_RUNTIME105 - Overview

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 105

• Message text: Errors while upgrading workbook properties

What causes this issue?

Workbooks from the 3.x Analyzer have workbook-specific settings. Errors
occurred while upgrading some of these settings to the 7.0 Analyzer.

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

System Response

All other areas and queries in the workbook are upgraded successfully;
only the 3.x workbook settings cannot be fully adjusted for the 7.0
Analyzer.

How to fix this error?

Manually adjust the workbook settings.

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_RUNTIME105 - Errors while upgrading workbook properties ?

  The SAP error message RSR_EXCEL_RUNTIME105 typically occurs when there are issues related to the upgrade of workbook properties in SAP Business Explorer (BEx) Analyzer, particularly when working with Excel workbooks that are connected to SAP BW (Business Warehouse). This error can arise due to various reasons, including compatibility issues, data source problems, or configuration settings.
  Causes of RSR_EXCEL_RUNTIME105 Error
  
  Compatibility Issues: The version of Excel or the BEx Analyzer may not be compatible with the SAP BW version you are using.
  Workbook Corruption: The workbook itself may be corrupted or contain invalid references.
  Data Source Changes: Changes in the underlying data source (e.g., InfoProviders, queries) that the workbook is based on can lead to this error.
  Authorization Issues: Insufficient authorizations for the user trying to upgrade the workbook properties.
  Excel Add-in Issues: Problems with the BEx Analyzer Excel add-in installation or configuration.
  Network Issues: Connectivity problems between Excel and the SAP BW system.
  
  Solutions to RSR_EXCEL_RUNTIME105 Error
  
  
  Check Compatibility:
  
  Ensure