In pivot table, if fresh data is added at the end of last row / column, we need to change the source manually to include them.
However, there are workarounds to dynamically include fresh data to pivot table.
I have shared 2 of them.
1. Using OFFSET and Defined Names
2. Converting source data to a TABLE format
#dynamicrangesusingoffset, #ExcelOFFSETFunctionforDynamicCalculations
![](https://s2.save4k.ru/pic/jHak8YSOSEA/maxresdefault.jpg)