Forum Discussion

Copper Contributor

Jan 22, 2019

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...

excel

office 365

frankb3892

Copper Contributor

Jan 23, 2019

I just did standard Insert>Pivot Table and it DID work! is there another quick access button that would work? Small request but would be great if MS could fix that.

Appreciate the clue into getting this working!!

JKPieterse

Silver Contributor

Jan 23, 2019

You could just right-click the button on the insert tab and select add to QAT.