Forum Discussion

Euan Campbell's avatar
Euan Campbell
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 you create.  

 

I followed this guide: https://support.office.com/en-us/article/Set-PivotTable-default-layout-options-efd8569c-f07a-43c1-9db2-4f2912a0f94e

 

However, I do not have a data option in Excel options.

 

 

 Also, reading another guide I looked in the advanced option here and there is still no button to edit defaults.

 

 

 Any help would be greatly appreciated.

 

I am using the most up to date verison.

 

Thanks

 

13 Replies

    • rankin_chris's avatar
      rankin_chris
      Copper Contributor

      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's avatar
        SergeiBaklan
        Diamond Contributor

        Chris,

         

        Data in Options was for a long while, what is added that