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

свернуть