Forum Discussion
MFadmin
Jun 16, 2022Copper Contributor
Programming error in Danish Excel for lists sourced by table names
Hi This error might only be relevant for the Danish languaged version of Excel (Microsoft 365 version, fully updated). When I make a list (drop down) in a cell, and I set the source to a named t...
Riny_van_Eekelen
Jun 16, 2022Platinum Contributor
MFadmin You can't use table references in data validation. Nothing to do with Danish language. In the List box you can reference a named ranges, a dynamic array, a regular range or you type all the options in the box.But table references are not allowed.