Excel Error Codes

The following table lists the error codes, names, and messages displayed, and the conditions they indicate.


CodeNameMessage and Condition
1000Invalid Coercion TypeThe specified coercion type is not supported The coercion type is not supported in the host application. (For example, OOXML and HTML coercion types are not supported in Excel.)
1002Invalid Coercion TypeThe specified coercion type is not compatible for this binding type. The solution developer provided an incompatible combination of coercion type and binding type.
1001Data Read ErrorThe current selection is not supported. The user's current selection is not supported. (That is, it is something different than the supported coercion types.)
1003Data Read ErrorThe specified rowCount or columnCount values are invalid. The user supplies invalid column or row counts.
1004Data Read ErrorThe current selection is not compatible for the specified coercion type. The current selection is not supported for the specified coercion type by this application.
1005Data Read ErrorThe specified startRow or startColumn values are invalid. The user supplies invalid startRow or startCol values.
1006Data Read ErrorCoordinate parameters cannot be used with coercion type "Table" when the table contains merged cells. The user tries to get partial data from a non-uniform table (that is, a table that has merged cells.)
1007Data Read ErrorThe size of the document is too large. The user tries to get a document larger than the size currently supported.
1008Data Read ErrorThe requested data set is too large. The user requests to read data beyond the data limits defined by the host add-ins.
1009Data Read ErrorThe specified file type is not supported. The user sends an invalid file type.
2000Data Write ErrorThe supplied data object type is not supported. An unsupported data object is supplied.
2001Data Write ErrorCannot write to the current selection. The user's current selection is not supported for a write operation. (For example, when the user selects an image.)
2002Data Write ErrorThe supplied data object is not compatible with the shape or dimensions of the current selection. Multiple cells are selected (and the selection shape does not match the shape of the data.)Multiple cells are selected (and the selection dimensions do not match the dimensions of the data.)
2003Data Write ErrorThe set operation failed because the supplied data object will overwrite data. A single cell is selected and the supplied data object overwrites data in the worksheet.
2004Data Write ErrorThe supplied data object does not match the size of the current selection. The user supplies an object larger than the current selection size.
2005Data Write ErrorThe specified startRow or startColumn values are invalid. The user supplies invalid startRow or startCol values.
2006Invalid Format ErrorThe format of the specified data object is not valid. The solution developer supplies an invalid HTML or OOXML string, a malformed HTML string, or an invalid OOXML string.
2007Invalid Data ObjectThe type of the specified data object is not compatible with the current selection. The solution developer supplies a data object not compatible with the specified coercion type.
2008Data Write ErrorTBD TBD
2009Data Write ErrorThe specified data object is too large. The user tries to set data beyond the data limits defined by host add-ins.
2010Data Write ErrorCoordinate parameters cannot be used with coercion type Table when the table contains merged cells. The user tries to set partial data from a non- uniform table (that is, a table that has merged cells.)
3000Binding Creation ErrorCannot bind to the current selection. The user's selection is not supported for binding. (For example, the user is selecting an image or other non-supported object.)
3001Binding Creation ErrorTBD TBD
3003Binding Creation ErrorNoncontiguous selections are not supported. The user is making multiple selections.
3004Binding Creation ErrorA binding cannot be created with the current selection and the specified binding type. There are several conditions under which this might happen. Please see the "Binding creation error conditions" section later in this article.
3006Binding Creation ErrorThe named item does not exist. The named item cannot be found. No content control or table with that name exists.
3007Binding Creation ErrorMultiple objects with the same name were found. Collision error: more than one content control with the same name exists, and fail on collision is set to true.
3008Binding Creation ErrorThe specified binding type is not compatible with the supplied named item. Named item cannot be bound to type. For example, a content control contains text but the developer tried to bind by using coercion type table.
3005Invalid Binding OperationOperation is not supported on this binding type. The developer sends a add row or add column operation on a binding type that is not table.
3009Invalid Binding OperationThe binding type is not supported. Used for backward compatibility.
3002Invalid Binding ErrorThe specified binding does not exist. The developer tries to bind to a non-existing or removed binding.
3010Unsupported Binding OperationThe selected content needs to be in table format. Format the data as a table and try again. The developer is trying to use the addRowsAsynch or deleteAllDataValuesAsynch methods of the TableBinding object on data of coercion type matrix.
4000Read Settings ErrorThe specified setting name does not exist. A nonexistent setting name is supplied.
4001Save Settings ErrorThe settings could not be saved. Settings could not be saved.
4002Settings Stale ErrorSettings could not be saved because they are stale. Settings are stale and developer indicated not to override settings.
5000Settings Stale ErrorThe operation is not supported. The operation is not supported in the current host. For example, document.getSelectionAsync is called from Outlook.
5001Internal ErrorAn internal error has occurred. Refers to an internal error condition, which can occur for any of the following reasons:
5001Internal ErrorAn add-in being used by another user sharing the workbook created a binding at approximately the same time, and your add-in needs to retry binding.
5001Internal ErrorAn unknown error occurred.
5001Internal ErrorThe operation failed.
5001Internal ErrorAccess was denied because the user is not a member of an authorized role.
5001Internal ErrorAccess was denied because secure, encrypted communication is required.
5001Internal ErrorData is stale and the user needs to confirm enabling the queries to refresh it.
5001Internal ErrorThe site collection CPU quota has been exceeded.
5001Internal ErrorThe site collection memory quota has been exceeded.
5001Internal ErrorThe session memory quota has been exceeded.
5001Internal ErrorThe workbook is in an invalid state and the operation can't be performed.
5001Internal ErrorThe session has timed out due to inactivity and the user needs to reload the workbook.
5001Internal ErrorThe maximum number of allowed sessions per user has been exceeded.
5001Internal ErrorThe operation was canceled by the user.
5001Internal ErrorThe operation can't be completed because it is taking too long.
5001Internal ErrorThe request can't be completed and needs to be retried.
5001Internal ErrorThe trial period of the product has expired.
5001Internal ErrorThe session has timed out due to inactivity.
5001Internal ErrorThe user doesn't have permission to perform the operation on the specified range.
5001Internal ErrorThe user's regional settings don't match the current collaboration session.
5001Internal ErrorThe user is no longer connected and must refresh or re-open the workbook.
5001Internal ErrorThe requested range doesn't exist in the sheet.
5001Internal ErrorThe user doesn't have permission to edit the workbook.
5001Internal ErrorThe workbook can't be edited because it is locked.
5001Internal ErrorThe session can't auto save the workbook.
5001Internal ErrorThe session can't refresh its lock on the workbook file.
5001Internal ErrorThe request can't be processed and needs to be retried.
5001Internal ErrorThe user's sign-in information couldn't be verified and needs to be re-entered.
5001Internal ErrorThe user has been denied access.
5001Internal ErrorThe shared workbook needs to be updated.
5002Permission DeniedThe requested operation is not allowed on the current document mode. The solution developer submits a set operation, but the document is in a mode that does not allow modifications, such as 'Restrict Editing'.
5003Event Registration ErrorThe specified event type is not supported by the current object. The solution developer tries to register or unregister a handler to an event that does not exist.
5004Invalid API callInvalid API call in the current context. An invalid call is made for the context, for example, trying to use a CustomXMLPart object in Excel.
5005Data StaleOperation failed because the data is stale on the server. The data on the server needs to be refreshed.
5006Session TimeoutThe document session timed out. Reload the document. The session has timed out.
5007Invalid API callThe enumeration is not supported in the current context. The enumeration is not supported in the current context.
5009Permission Denied Access DeniedThe add-in does not have permission to call the specific API.
6000Invalid nodeThe specified node was not found. The CustomXmlPart node was not found.
6100Custom XML errorCustom XML error Invalid API call
7000Invalid IdThe specified Id does not exist. Invalid ID
7001Invalid navigationThe object is located in a place where navigation is not supported. The user can find the object, but cannot navigate to it. (For example, in Word, the binding is to the header, footer, or a comment.)
7002Invalid navigationThe object is locked or protected. The user is trying to navigate to a locked or protected range.
7004Invalid navigationThe operation failed because the Index is out of range. The user is trying to navigate to an index that is out of range.
8000Missing ParameterWe couldn't format the table cell because some parameter values are missing. Double-check the parameters and try again. The cellFormat method is missing some parameters. For example, there are missing cells, format, or tableOptions parameters.
8010Invalid valueOne or more of the cells parameters have values that aren't allowed. Double-check the values and try again. The common cells reference enumeration is not defined. For example, All, Data, Headers.
8011Invalid valueOne or more of the tableOptions parameters have values that aren't allowed. Double-check the values and try again. One of the values in tableOptions is invalid.
8012Invalid valueOne or more of the format parameters have values that aren't allowed. Double-check the values and try again. One of the values in the format is invalid.
8020Out of rangeThe row index value is out of the allowed range. Use a positive value (0 or higher) that's less than the number of rows. The row index is more than the biggest row index of the table or less than 0.
8021Out of rangeThe column index value is out of the allowed range. Use a positive value (0 or higher) that's less than the number of columns. The column index is more than the biggest column index of the table or less than 0.
8022Out of rangeThe value is out of the allowed range. Some of the values in the format are out of the supported ranges.
9016Permission deniedPermission denied Access is denied.
12004  
12005  
12007  



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext