Forum Discussion
Setting pivot table defaults
I have grown tired of having to configure pivot tables how I want them every time they are created. I was pleased to hear about a new(ish) feature that allows you to set the default for all pivots y...
According to this,
https://technet.microsoft.com/en-us/office/mt465751.aspx
The latest Semi-Annual update Version 1705 (Build 8201.2193) says it includes the personalized default PivotTable layout. I just updated to this version but still do not have Data in File>Options.
Chris,
Data in Options was for a long while, what is added that
Thanks. When I go to File>Account, it shows Version 1705 (Build 8201.2193 Click-to-Run).
But when I go to File>Options, I don't see Data in the sidebar at all.
I see. Tried to check but found nothing about that.
I found the setting... but it was in File>Options>Advanced>Data. Different versions must have the Data section in a different place?