Excel Table Appears to Automatically Expand but drop down list doesn't update

I finally figured this out. The result is when you add an item to a table, even at the bottom, the drop down list automatically expands to show all values in your table of drop down items.

Basically, create a named range to be equal to your defined table[column_header] which contains your list. I'll use a list of fruits as an example.

1. Type in a header, (i.e. "name")
2. Type in some names of fruits below that header, one per row (i.e. Apples, Bananas, Oranges)
3. Select the header cell, plus the 3 cells below that and turn it into a Table (make sure to check the option "My table has headers")
4. Give that table a name that makes sense (i.e."tbl_fruit")
5. Go to the Formulas tab, and select Name Manager
6. Click "New" button
7. Give your list a Name that makes sense (i.e. "list_fruit")
8. Give the Refers to field this formula: =tbl_fruit[name]
9. Click OK

You can then use that "list_fruit" named range as the Source when setting up your Data Validation list (i.e. =list_fruit). Since the list refers to the table named "tbl_fruit" now, any time that table changes, the results from named range "list_fruit" changes automatically. The named range is the table.