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

RSR_EXCEL_RUNTIME118 - Overview

• 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