Forum Discussion
Dynamic named range with Pivot table
Hi, I'm trying to use a dynamic named range with a pivot table so when new data is added, the pivot table expands to capture this, however when I try to change the range to this dynamic named ran...
Hi clh_1496
I really propose to use a formatted table instead of named ranges. It's much simpler and there is no need for OFFSET formulas which could also have an impact on performance in large data sets.