I am having issues trying to use a table for a data validation list. In my case I have a single column table - created by using the "Format As Table" feature. I have named my table ListStatus.
In the Data Validation dialog box I have selected List and entered ListStatus as the Source. I get an error when doing this.
How can I reference a single column table as the source for data validation?
Thanks in advance.