excel pivot refresh on multiple tables of same data


If I use the same data for multiple pivots (meaning I define a named range to be




(in other words, have the data self-size itself for additional rows and columns


...if I use that named range and create multiple pivots, do all pivots refresh when one is refreshed? 

1 Reply
Not necessarily. Only of all pivot tables use the same cache. Of course pressing refreshAll should update them all...
I would convert your data to a Table (Insert, Table button), then the dynamic range name is no longer needed.