Forum Discussion
Setting Default Pivot Table Options does not work (Excel 2016?)
Hello All, I recently discovered the new feature in Excel 2016 that allows you to set the default options for pivot tables in Options>Data>Edit Default Layout>PivotTable Options. I was very exci...
I am still having this issue, despite using the "insert ->pivot table" option. It used to work and then stopped. No idea what's going on, but it sucks to have to create number formatting every single time. Anyone have any tips/tricks for getting this to work in Excel 365?