In MS Excel, is there a way to automatically include the last row of new data from a data sheet into the corresponding pivot table without having to manually adjust the data
![Auto Refresh Pivot Table | How to Refresh Pivot Table automatically when source data changes Excel - YouTube Auto Refresh Pivot Table | How to Refresh Pivot Table automatically when source data changes Excel - YouTube](https://i.ytimg.com/vi/AGdLbnk16o4/maxresdefault.jpg)
Auto Refresh Pivot Table | How to Refresh Pivot Table automatically when source data changes Excel - YouTube
![Auto-Refresh Pivot Tables and Pivot Charts when Source Data Changes | Ultimate Excel Dashboard Ep. 4 - YouTube Auto-Refresh Pivot Tables and Pivot Charts when Source Data Changes | Ultimate Excel Dashboard Ep. 4 - YouTube](https://i.ytimg.com/vi/Xdq7SE-z-Aw/mqdefault.jpg)