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

SAP Error Message - Details

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_EXCEL_RUNTIME113 - Cannot upgrade workbook; repository sheets are missing ?

  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 missing repository sheets.
  
  Solution:
  
  Check for Repository Sheets: Open the workbook and verify if the required repository sheets are present. If they are missing, you may need to recreate them or restore them from a backup.
  Recreate the Workbook: If the workbook is corrupted or missing essential components, consider recreating the workbook from scratch using the latest version of SAP Analysis for Office.
  Update SAP Analysis for Office: Ensure that you are using the latest version of SAP Analysis for Office. Sometimes, upgrading to the latest version can resolve compatibility issues.
  Check Data Connections: Verify that all data connections and sources are correctly configured and accessible. If there have been changes to the data sources, update the workbook accordingly.
  Consult Documentation: Refer to the SAP documentation or support resources for specific guidance on handling this error, as there may be version-specific instructions or patches available.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message. SAP frequently updates its knowledge base with solutions for common problems.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Backup: Always maintain backups of your workbooks before making significant changes or upgrades to avoid data loss.
  
  If the problem persists after trying the above solutions, consider reaching out to SAP support for further assistance.