This means Excel doesn’t make the changes automatically. Figure I Microsoft Lists exports the list to an Excel query. Now, let’s add a record to the list and watch it update the web query.

Populate the Excel dropdown by referencing the named range, Animals_List. As you can see in Figure D, Excel populates the dropdown using the list of animals on the Lists sheet — a completely ...