How To Fix RSR_EXCEL_RUNTIME113 - Cannot upgrade workbook; repository sheets are missing

RSR_EXCEL_RUNTIME113 - Overview

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 113

• Message text: Cannot upgrade workbook; repository sheets are missing

What causes this issue?

While upgrading the 3.x workbook, the metadata for queries in the
workbook, which is stored in the hidden sheets 'SAPBEXqueries' and
'SAPBEXfilters' could not be read. This was because these hidden
repository sheets were not found in the workbook.

System Response

The workbook is not upgraded.

How to fix this error?

This problem can occur if the workbook is corrupt and the hidden sheets
cannot be retrieved as a result. In this case, try opening the workbook
in the 3.x Analyzer and check whether you can refresh the workbook
correctly. If you cannot refresh the workbook, try upgrading it again.
Also check whether the worksheets were accidentally deleted, as this may
be the reason why the workbook cannot be upgraded.

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.

RSR_EXCEL_RUNTIME113 - Details

• The SAP error message RSR_EXCEL_RUNTIME113 indicates that there is an issue with upgrading a workbook in SAP Analysis for Microsoft Office (AO) due to missing repository sheets. This typically occurs when the workbook you are trying to upgrade is not properly linked to the required data sources or repository sheets that are necessary for the upgrade process.
  
  Cause:
  
  Missing Repository Sheets: The workbook may have been created or modified in a way that it no longer contains the necessary repository sheets that are required for the upgrade.
  Version Compatibility: The workbook may have been created in an older version of SAP Analysis for Office, and the upgrade process is unable to find the necessary components to complete the upgrade.
  Corrupted Workbook: The workbook file may be corrupted or improperly saved, leading to missing components.
  Changes in Data Sources: If the data sources or connections have changed since the workbook was created, it may lead to