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...
Hi Euan,
This functionality was introduced in May this year for Office 365 subscribers in the build 8067.2115 (Current Channel).
It is unavailable if you are on another version and/or on build before (e.g. Deferred Channel)
https://technet.microsoft.com/en-us/office/mt465751.aspx
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.