Excel.CalcErrorCellValueSubType enum
Represents types of #CALC! errors.
Remarks
Fields
| arrayOfArrays = "ArrayOfArrays" | An error caused by including an array in an array. Displays as error type #CALC! in Excel. |
| arrayOfRanges = "ArrayOfRanges" | An error caused by including a range in an array. Displays as error type #CALC! in Excel. |
| dataTableReferencedPendingFormula = "DataTableReferencedPendingFormula" | An error caused by a data table referencing a pending formula. The pending formula is likely asynchronous. Displays as error type #CALC! in Excel. |
| emptyArray = "EmptyArray" | An error caused by an empty array. Displays as error type #CALC! in Excel. |
| eRegexReplaceCharLimit = "ERegexReplaceCharLimit" | An error caused by text that's longer than 65,535 characters. Displays as error type #CALC! in Excel. |
| externalQueryRef = "ExternalQueryRef" | An error caused by a reference to a Power Query query in a different workbook. Displays as error type #CALC! in Excel. |
| functionInCell = "FunctionInCell" | An error caused by a cell's formula evaluating to a function or function reference. Displays as error type #CALC! in Excel. |
| imageExceedsSizeLimit = "ImageExceedsSizeLimit" | An error caused by a formula generating a request containing images that's too large for an external code service. Displays as error type #CALC! in Excel. |
| invalidPythonObject = "InvalidPythonObject" | An error caused by a formula referencing a value returned by an external code service in a different workbook. Displays as error type #CALC! in Excel. |
| lambdaInCell = "LambdaInCell" | An error caused by a cell's formula evaluating to a lambda value. Displays as error type #CALC! in Excel. |
| pythonGridQuery = "PythonGridQuery" | An error caused by a Power Query query referencing data in a sheet. Displays as error type #CALC! in Excel. |
| pythonPowerQueryDataUploadEtagChanged = "PythonPowerQueryDataUploadEtagChanged" | An error caused by a Power Query query ID change. Displays as error type #CALC! in Excel. |
| pythonPowerQueryDataUploadSizeLimitExceeded = "PythonPowerQueryDataUploadSizeLimitExceeded" | An error caused by Power Query exceeding the limit for data uploaded to an external code service. Displays as error type #CALC! in Excel. |
| queryInCell = "QueryInCell" | An error caused by a formula returning a reference to a Power Query query. Displays as error type #CALC! in Excel. |
| requestTooLarge = "RequestTooLarge" | An error caused by a formula generating too large a request for an external code service. Displays as error type #CALC! in Excel. |
| textOverflow = "TextOverflow" | An error caused by a cell's formula returning a string that exceeds the maximum of 32767 characters. Displays as error type #CALC! in Excel. Some characters, like emoji, may appear to be one character in the Excel UI but are actually processed as surrogate characters. A surrogate character counts as multiple characters toward the maximum character limit. |
| tooDeeplyNested = "TooDeeplyNested" | An error caused by a |
| tooManyCells = "TooManyCells" | An error caused by a function referencing too many cells. Displays as error type #CALC! in Excel. |
| unexpectedReturnValue = "UnexpectedReturnValue" | An error caused by an external code service returning an unexpected result. Displays as error type #CALC! in Excel. |
| uninitializedPythonObject = "UninitializedPythonObject" | An error caused by an uninitialized Python Object. Displays as error type #CALC! in Excel. |
| unknown = "Unknown" | An unknown type of error. Displays as error type #CALC! in Excel. |
| unsupportedLifting = "UnsupportedLifting" | An error caused by attempting to lift an unsupported formula (such as a Dynamic UDF) over an array. Displays as error type #CALC! in Excel. |