Forum Discussion

Copper Contributor

Sep 06, 2017

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

excel

SergeiBaklan

Diamond Contributor

Sep 06, 2017

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

rankin_chris
Copper Contributor
Sep 14, 2017
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.
- SergeiBaklan
  Diamond Contributor
  Sep 14, 2017
  Chris,
  
  Data in Options was for a long while, what is added that
  - rankin_chris
    Copper Contributor
    Sep 14, 2017
    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.
Euan Campbell
Copper Contributor
Sep 06, 2017
Thank you Sergei.

Euan