EPPlus
EPPlus copied to clipboard
Pivot table with filters add new rows on refresh
Pivot tables with a page field, item filter or a slicer adds new items as visible when refreshing the pivot table. Excel keeps the filter when refreshing the pivot table, hiding values not matched by the filter.