Validating excel spreadsheets
Databases developed in programs other than Excel tend to be more customized and thus require more validation.
It's more practical to turn off certain menu options and require users to work with Excel spreadsheets only from certain locations or create read-only templates. For example, if you are creating read-only templates, "you have to show that ordinary users can't modify them," said Harrison.
If a new item is entered, you will be asked if you want to add it to the existing list.
Similar to DV0062, but lists with multiple columns will be sorted correctly.
Anything not documented is no better than a rumor as far as compliance is concerned.
DV0072 -Data Validation Combobox - Add/Sort -- Click a cell that contains a data validation list, and a combobox appears -- font size can be set, more than 8 rows displayed, autocomplete can be enabled.
"In theory, this is a great idea, but few people do it," he said; Replace Excel with databases.