Data Sources for Data Validation, DynaRanges, ComboBoxes, and Lists


For Data Validation, DynaRanges, ComboBoxes, and Lists, you can use several data sources. The type of data source can be a subset, a formula, or an ODBC query.

Note: when using a source formula or ODBC query, there is one constraint to consider. If the number of elements in the data set is divisible by three, and the last value is numeric, the corresponding process assumes it is handling a subset-like data structure. It will then only show the first, fourth, seventh, etc. element from the source data set. In some dialogs, you can select the option “Show Alias”. It would then only show the second, fifth, eighth, etc. element as first alias, and the third, sixth, and ninth element etc. as second alias.

Was this post helpful?
NoYes (-8 rating, 8 votes)