I have Excel 2013 through an Office 365 subscription.
I created a copy of a pivot table in the same tab so I could compare some results between different teams. I want to refresh only one of the pivot table but when I click refresh, every pivot table on every tab refreshes with it. It make no difference whether I right-click refresh within the target PVT, or I go to Pivottable Tools/Analyze/Data and take care to select "Refresh" rather than "Refresh All".
Is 2013 hardwired to only refresh every pivot table in a workbook?
Bookmarks