How To Fix RSR_EXCEL_RUNTIME105 - Errors while upgrading workbook properties

SAP Error Message - Details

• 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 that the versions of Excel, BEx Analyzer, and SAP BW are compatible. Refer to SAP notes or documentation for version compatibility.
  
  
  
  Repair or Recreate the Workbook:
  
  If the workbook is corrupted, try to repair it or create a new workbook based on the same queries and data sources.
  
  
  
  Review Data Sources:
  
  Check if there have been any changes to the InfoProviders or queries that the workbook uses. Ensure that they are still valid and accessible.
  
  
  
  Check Authorizations:
  
  Verify that the user has the necessary authorizations to access the data sources and perform the upgrade.
  
  
  
  Reinstall BEx Analyzer:
  
  If there are issues with the BEx Analyzer add-in, consider reinstalling it to ensure it is properly configured.
  
  
  
  Network Connectivity:
  
  Ensure that there are no network issues preventing Excel from connecting to the SAP BW system.
  
  
  
  SAP Notes and Support:
  
  Check for any relevant SAP Notes that address this specific error. SAP frequently updates its knowledge base with solutions for known issues.
  
  
  
  Log Analysis:
  
  Analyze the logs in SAP BW for any additional error messages or warnings that could provide more context about the issue.
  
  
  
  Related Information
  
  SAP Notes: Search for specific SAP Notes related to RSR_EXCEL_RUNTIME105 for any patches or updates that may resolve the issue.
  Documentation: Review the official SAP documentation for BEx Analyzer and SAP BW for best practices and troubleshooting steps.
  Community Forums: Engage with SAP community forums or user groups where similar issues may have been discussed and resolved.
  
  If the problem persists after trying the above solutions, consider reaching out to SAP support for further assistance.