2 May 2013
I've set up a table with some team names that I want to use in a Data Validation list. The reason I formatted my list in an Excel table is because I want the range to dynamically update when I add or remove teams from the list.
Now, if you've ever tried to reference an Excel Table as your Data Validation lists... then you probably got the error: "The formula you typed contains and error". Here are two ways to fix this...
Full article: Excel Tables as source for data validation lists