Updating data in excel automatically
Here I will tell you a good way to auto update the drop down list when adding new data to the original data. And when you add new data to the original data range, the drop down list updates at the meanwhile.
In Excel, we usually create a drop down list for some daily work.There are two kinds of data refresh: You can refresh the data in the workbook manually at any time.You can refresh all data, which is the default, or you can manually choose the tables and columns to refresh for individual data sources.These changes can include adding columns or tables, or changing the rows that are imported.This topic provides the following information: Note that addition of data, changing data, or editing filters always triggers recalculation of any columns or formulas that depend on that data source. For more information, see If you need to update column metadata or get recent data for designing new formulas, you can manually refresh your data at any time.