JavaScript API for Office error codes

This article documents the error messages you might encounter while using the JavaScript API for Office (Office.js).

Applies to: Office Add-ins | SharePoint Add-ins | Excel | Outlook | PowerPoint | Project | Word

Error codes

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

Error.code Error.name Error.message Condition
1000 Invalid Coercion Type The 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.)
1001 Data Read Error The current selection is not supported. The user's current selection is not supported. (That is, it is something different than the supported coercion types.)
1002 Invalid Coercion Type The specified coercion type is not compatible for this binding type. The solution developer provided an incompatible combination of coercion type and binding type.
1003 Data Read Error The specified rowCount or columnCount values are invalid. The user supplies invalid column or row counts.
1004 Data Read Error The current selection is not compatible for the specified coercion type. The current selection is not supported for the specified coercion type by this application.
1005 Data Read Error The specified startRow or startColumn values are invalid. The user supplies invalid startRow or startCol values.
1006 Data Read Error Coordinate 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.)
1007 Data Read Error The size of the document is too large. The user tries to get a document larger than the size currently supported.
1008 Data Read Error The requested data set is too large. The user requests to read data beyond the data limits defined by the host add-ins.
1009 Data Read Error The specified file type is not supported. The user sends an invalid file type.
2000 Data Write Error The supplied data object type is not supported. An unsupported data object is supplied.
2001 Data Write Error Cannot 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.)
2002 Data Write Error The 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.)
2003 Data Write Error The 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.
2004 Data Write Error The supplied data object does not match the size of the current selection. The user supplies an object larger than the current selection size.
2005 Data Write Error The specified startRow or startColumn values are invalid. The user supplies invalid startRow or startCol values.
2006 Invalid Format Error The 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.
2007 Invalid Data Object The 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.
2008 Data Write Error TBD TBD
2009 Data Write Error The specified data object is too large. The user tries to set data beyond the data limits defined by host add-ins.
2010 Data Write Error Coordinate 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.)
3000 Binding Creation Error Cannot 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.)
3001 Binding Creation Error TBD TBD
3002 Invalid Binding Error The specified binding does not exist. The developer tries to bind to a non-existing or removed binding.
3003 Binding Creation Error Noncontiguous selections are not supported. The user is making multiple selections.
3004 Binding Creation Error A 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.
3005 Invalid Binding Operation Operation 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.
3006 Binding Creation Error The named item does not exist. The named item cannot be found. No content control or table with that name exists.
3007 Binding Creation Error Multiple 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.
3008 Binding Creation Error The 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.
3009 Invalid Binding Operation The binding type is not supported. Used for backward compatibility.
3010 Unsupported Binding Operation The 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.
4000 Read Settings Error The specified setting name does not exist. A nonexistent setting name is supplied.
4001 Save Settings Error The settings could not be saved. Settings could not be saved.
4002 Settings Stale Error Settings could not be saved because they are stale. Settings are stale and developer indicated not to override settings.
5000 Settings Stale Error The operation is not supported. The operation is not supported in the current host. For example, document.getSelectionAsync is called from Outlook.
5001 Internal Error An internal error has occurred. Refers to an internal error condition, which can occur for any of the following reasons:
An 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.
An unknown error occurred.
The operation failed.
Access was denied because the user is not a member of an authorized role.
Access was denied because secure, encrypted communication is required.
Data is stale and the user needs to confirm enabling the queries to refresh it.
The site collection CPU quota has been exceeded.
The site collection memory quota has been exceeded.
The session memory quota has been exceeded.
The workbook is in an invalid state and the operation can't be performed.
The session has timed out due to inactivity and the user needs to reload the workbook.
The maximum number of allowed sessions per user has been exceeded.
The operation was canceled by the user.
The operation can't be completed because it is taking too long.
The request can't be completed and needs to be retried.
The trial period of the product has expired.
The session has timed out due to inactivity.
The user doesn't have permission to perform the operation on the specified range.
The user's regional settings don't match the current collaboration session.
The user is no longer connected and must refresh or re-open the workbook.
The requested range doesn't exist in the sheet.
The user doesn't have permission to edit the workbook.
The workbook can't be edited because it is locked.
The session can't auto save the workbook.
The session can't refresh its lock on the workbook file.
The request can't be processed and needs to be retried.
The user's sign-in information couldn't be verified and needs to be re-entered.
The user has been denied access.
The shared workbook needs to be updated.
5002 Permission Denied The 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'.
5003 Event Registration Error The 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.
5004 Invalid API call Invalid API call in the current context. An invalid call is made for the context, for example, trying to use a CustomXMLPart object in Excel.
5005 Data Stale Operation failed because the data is stale on the server. The data on the server needs to be refreshed.
5006 Session Timeout The document session timed out. Reload the document. The session has timed out.
5007 Invalid API call The enumeration is not supported in the current context. The enumeration is not supported in the current context.
5009 Permission Denied Access Denied The add-in does not have permission to call the specific API.
6000 Invalid node The specified node was not found. The CustomXmlPart node was not found.
6100 Custom XML error Custom XML error Invalid API call
7000 Invalid Id The specified Id does not exist. Invalid ID
7001 Invalid navigation The 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.)
7002 Invalid navigation The object is locked or protected. The user is trying to navigate to a locked or protected range.
7004 Invalid navigation The operation failed because the Index is out of range. The user is trying to navigate to an index that is out of range.
8000 Missing Parameter We 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.
8010 Invalid value One 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.
8011 Invalid value One 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.
8012 Invalid value One 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.
8020 Out of range The 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.
8021 Out of range The 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.
8022 Out of range The value is out of the allowed range. Some of the values in the format are out of the supported ranges.
9016 Permission denied Permission denied Access is denied.

Binding creation error conditions

When a binding is created in the API, indicate the binding type that you want to use. The following tables lists the binding types and the resulting binding behaviors that are expected.

Behavior in Excel

The following table summarizes binding behavior in Excel.

Specified Binding Type Actual Selection Behavior
Matrix Range of cells (including within a table, and single cell) A binding of type matrix is created on the selected cells. No modification in the document is expected.
Matrix Text selected in the cell A binding of type matrix is created on the whole cell. No modification in the document is expected.
Matrix Multiple selection/invalid selection (For example, user selects a picture, object, or Word Art.) The binding cannot be created.
Table Range of cells (includes single cell) The binding cannot be created.
Table Range of cell within a table (includes single cell within a table, or the whole table, or text within a cell in a table) A binding is created in the whole table.
Table Half selection in a table and half selection outside the table The binding cannot be created.
Table Text selected in the cell (not in the table.) The binding cannot be created.
Table Multiple selection/invalid selection (For example, user selects a picture, object, Word Art, etc.) The binding cannot be created.
Text Range of cells The binding cannot be created.
Text Range of cells within a table The binding cannot be created.
Text Single cell A binding of type text is created.
Text Single cell within a table A binding of type text is created.
Text Text selected in the cell A binding of type text in the whole cell is created.

Behavior in Word

The following table summarizes binding behavior in Word.

Specified Binding Type Actual Selection Behavior
Matrix Text The binding cannot be created.
Matrix Whole table A binding of type matrix is created.Document is changed and a content control must wrap the table.
Matrix Range within a table The binding cannot be created.
Matrix Invalid selection (for example, multiple, invalid objects, etc.) The binding cannot be created.
Table Text The binding cannot be created.
Table Whole table A binding of type text is created.
Table Range within a table The binding cannot be created.
Table Invalid selection (for example, multiple, invalid objects, etc.) The binding cannot be created.
Text Whole table A binding of type text is created.
Text Range within a table The binding cannot be created.
Text Multiple selection The last selection will be wrapped with a content control and a binding to that control. A content control of type text is created.
Text Invalid selection (for example, multiple, invalid objects, etc.) The binding cannot be created.

Additional resources

Page Content End -->