I am a reporting analyst and working on excel to perform most of my task. To summarize data, i frequently use Pivot table. One of the major problem with pivot, if there is any addition or deletion of records then i need to change the data source for same. I use multiple pivots for reporting and this process kills a lot of bandwidth. Can you suggest me a way that will automatically change the range of data source?