xlLinkedDataTypeState |
| Specifies the state of cells that may contain Linked data types such as Stocks or Geography. |
| xlLinkedDataTypeStateBrokenLinkedData | There is a valid Linked data type in the cell, but entity no longer exists on the service (3) |
| xlLinkedDataTypeStateDisambiguationNeeded | 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 (2) |
| xlLinkedDataTypeStateFetchingData | The Linked data type in the cell is in the middle of refreshing new data from the service (4) |
| xlLinkedDataTypeStateNone | The cell does not contain any Linked data types (0) |
| xlLinkedDataTypeStateValidLinkedData | The cell contains a Linked data type (1) |
| xlLinkedDataTypeStateBrokenLinkedData |
| There is a valid Linked data type in the cell, but entity no longer exists on the service (3) |
| xlLinkedDataTypeStateDisambiguationNeeded |
| 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 (2) |
| xlLinkedDataTypeStateFetchingData |
| The Linked data type in the cell is in the middle of refreshing new data from the service (4) |
| xlLinkedDataTypeStateNone |
| The cell does not contain any Linked data types (0) |
| xlLinkedDataTypeStateValidLinkedData |
| The cell contains a Linked data type (1) |
| REMARKS |
| * Added in 2019. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top