How To Fix RSR_EXCEL_RUNTIME117 - Local formula &1 is not correctly defined

RSR_EXCEL_RUNTIME117 - Overview

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 117

• Message text: Local formula &1 is not correctly defined

What causes this issue?

For more information about the error that occurred while creating the
local formula, see the related messages for this error.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

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_RUNTIME117 - Local formula &1 is not correctly defined ?

  The SAP error message RSR_EXCEL_RUNTIME117 with the description "Local formula &1 is not correctly defined" typically occurs when there is an issue with the Excel formula used in a report or analysis that is being executed in SAP. This error can arise in various contexts, such as when using SAP Business Explorer (BEx) or SAP Analysis for Office.
  Causes:
  
  Incorrect Formula Syntax: The formula defined in the Excel sheet may have syntax errors or may not conform to the expected format.
  Missing References: The formula may reference cells or ranges that do not exist or are incorrectly defined.
  Unsupported Functions: The formula may use functions that are not supported by SAP or the specific version of the tool being used.
  Data Type Mismatch: The data types of the values being used in the formula may not be compatible, leading to errors.
  Excel Version Compatibility: There may be compatibility issues between the version of Excel being used