Pivot Table Format Defaults
December 13, 2022 - by Bill Jelen

Problem: I hate Compact layout in Pivot Tables. I want all future pivot tables to start in Tabular.
Strategy: A November 2016 update to Office 365 introduces the ability to set defaults for all future pivot tables. Go to File, Options, Advanced, Data and choose Edit Default Layout.

Gotcha: If you have an older version of Excel, you can buy the Pivot Power Premium add-in from Debra Dalgleish at Contextures.com. This add-in addresses many annoyances with pivot tables. Read more at http://www.mrx.cl/pppdebra.
This article is an excerpt from Power Excel With MrExcel
Title photo by André Roma on Unsplash