Skip to main content

XlLinkedDataTypeState enumeration

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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>