Unfortunately I'm not aware of any plans to fix it and it's still like this in Excel 2016! It's a shame you can't just use the Table Structured Reference as your Data Validation list source. No named range, no Structured references: Then when you add items to the bottom of the Table your Data Validation List source automatically updates*, almost like magic. Method 3: Simply reference the cells in the table:
No need to use INDIRECT, and it will still dynamically update as new data is added or removed from the table just like the first example. Now I can set up my Data Validation list like this: In the name manager I’ve set up a new named range called Team_Table and referenced it to the Team column (and only column in this case) of Table1: In this example my table is in cells A2:A7 and is called Table1. Method 2: Give your Table another name in the name manager. Method 1: Use the INDIRECT function with the tables structured references like this: “The formula you typed contains and error”. Now, if you’ve ever tried to reference an Excel Table as your Data Validation lists source like this: My table’s name is Table1, as you can see here in the name box: 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. I’ve set up a table with some team names that I want to use in a Data Validation list. Excel for Customer Service Professionals.
0 kommentar(er)
