I recently discovered that you can add buttons on quick access toolbar to let you instantly convert your pivot table to classic view, and then disable all subtotaling. Is there a similar button that lets you disable the auto resizing of column width when you refresh the pivot?
Bookmarks