XlLinkedDataTypeState enumeration (Excel)
Indicates the state of cells that may contain Linked data types such as Stocks or Geography. These are the possible values of the Range.LinkedDataTypeState property.
| Name | Value | Description |
|---|---|---|
| xlLinkedDataTypeStateNone | 0 | The cell does not contain any Linked data types. |
| xlLinkedDataTypeStateValidLinkedData | 1 | The cell contains a Linked data type. |
| xlLinkedDataTypeStateDisambiguationNeeded | 2 | The cell needs to be disambiguated by the user before a Linked data type can be inserted. For example, if the user types "New York" into a cell and attempts to convert it to a "Geography" data type, they may need to select whether they meant New York State or New York City. Until they do so, the cell will be in this state. |
| xlLinkedDataTypeStateBrokenLinkedData | 3 | There is a valid Linked data type in the cell, but entity no longer exists on the service. |
| xlLinkedDataTypeStateFetchingData | 4 | The Linked data type in the cell is in the middle of refreshing new data from the service. |
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.