How To Fix RSR_EXCEL_RUNTIME118 - Errors while upgrading workbook; workbook is not valid

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 118

• Message text: Errors while upgrading workbook; workbook is not valid

What causes this issue?

An error occurred while reading the metadata associated with this query
in the workbook. This metadata is stored in two hidden repository
sheets: SAPBEXqueries and SAPBEXfilters. The error may have been caused
by corrupt metadata in the hidden sheets. It is also possible that these
are BW 2.x workbooks that were opened directly in the BEx Analyzer from
SAP NetWeaver 7.0.

System Response

Since the metadata was not read correctly, it is possible that the query
in the workbook was not upgraded correctly. The upgrade process
continued, but there may be consistency issues, which you should check
for by refreshing the workbook. If you are working with a BW 2.x
workbook, the workbook may not be upgraded at all.

How to fix this error?

First try refreshing the workbook in the 7.0 Analyzer to check whether
the query refreshes correctly despite these errors and whether these
errors can be ignored. If the query refreshes correctly, the warning can
be ignored and the workbook can be saved.
If the workbook does not refresh correctly in the 7.0 Analyzer, check
whether it refreshes correctly in the 3.x Analyzer. If errors occur
while refreshing the workbook in the 3.x Analyzer, the workbook is
probably corrupt. You should then investigate the cause of this in the
3.x Analyzer.
If the workbook refreshes correctly in the 3.x Analyzer, another
possible cause could be that the Excel workbook or worksheet is
protected. Try unprotecting the worksheet or workbook and upgrading it
again in the 7.0 Analyzer.
If the workbook was created using 2.x Analyzer, save the workbook again
in the 3.x Analyzer and try opening it in the 7.0 Analyzer.
If none of these solutions resolve the problem, there may be other
compatibility issues between the 3.x and the 7.0 Analyzer. In such
cases, check whether you can make adjustments manually with the 7.0
Analyzer to solve the problem.

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_RUNTIME118 - Errors while upgrading workbook; workbook is not valid ?

  The SAP error message RSR_EXCEL_RUNTIME118 typically occurs when there is an issue with the Excel workbook that you are trying to upgrade or use in SAP BW (Business Warehouse). This error indicates that the workbook is not valid, which can be due to several reasons. Below are some common causes, potential solutions, and related information to help you resolve this issue.
  Causes:
  
  Corrupted Workbook: The Excel workbook may be corrupted or improperly formatted.
  Incompatible Versions: The version of Excel used to create the workbook may not be compatible with the version of SAP BW you are using.
  Missing or Incorrect Data Sources: The workbook may reference data sources that are no longer valid or have been changed.
  Unsupported Features: The workbook may contain features or elements that are not supported by SAP BW.
  Excel Add-ins: Certain Excel add-ins or macros may interfere with the workbook's functionality in SAP.
  
  Solutions:
  
  
  Check Workbook Integrity:
  
  Open the workbook in Excel and check for any errors or issues. Try saving it in a different format (e.g., .xlsx) and then re-uploading it to SAP.
  
  
  
  Recreate the Workbook:
  
  If the workbook is corrupted, consider recreating it from scratch or using a backup version if available.
  
  
  
  Verify Data Sources:
  
  Ensure that all data sources referenced in the workbook are valid and accessible. Update any references to point to the correct data sources.
  
  
  
  Compatibility Check:
  
  Make sure that the version of Excel you are using is compatible with your SAP BW version. If necessary, upgrade or downgrade Excel.
  
  
  
  Remove Unsupported Features:
  
  Check for any unsupported features in the workbook (like certain formulas, charts, or formatting) and remove or replace them.
  
  
  
  Disable Add-ins:
  
  Temporarily disable any Excel add-ins or macros that might be affecting the workbook's functionality.
  
  
  
  Use SAP Notes:
  
  Check the SAP Support Portal for any relevant SAP Notes or patches that address this specific error. There may be updates or fixes available.
  
  
  
  Consult Documentation:
  
  Review the SAP BW documentation for any specific guidelines on workbook creation and compatibility.
  
  
  
  Related Information:
  
  SAP Notes: Search for SAP Notes related to RSR_EXCEL_RUNTIME118 in the SAP Support Portal. These notes may provide specific fixes or workarounds.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they found effective.
  SAP BW Documentation: Refer to the official SAP BW documentation for best practices in creating and managing workbooks.
  
  By following these steps, you should be able to identify the cause of the RSR_EXCEL_RUNTIME118 error and implement a suitable solution. If the problem persists, consider reaching out to your SAP support team for further assistance.