Pivot Table Settings (Excel Tune Up - Part 2)

This week...Pivot Table settings

If you missed part 1 you'll find it here

In this week's instalment we'll take a look at Pivot Table settings.

1. How to turn off the dreaded (or loved) GETPIVOTDATA formula.

Quickest way is to click in a Pivot Table and go to Options > Generate GetPivotData and untick it.

Alternatively you can go to File > Options Formulas

2. Default Pivot Table settings

Have you ever wanted to turn off Column Autofit for all future pivot tables? Well now you can, along with changing a whole bunch of other default settings, such as Tabular layout and no subtotals.

*** However, this only currently available in the latest release of Excel 2016 in Office 365, to be more precise the Monthly Channel Version 1704 (Build 8067.2115), and I don't think this will flow through to the slowest Office 365 channel until March 2018. ***

For those with the latest release you will see the new Data tab under File > Options

You can then click on the Edit Default Layout

The whole Channel concept for Office 365 is a little confusing and unexpected for new-comers. I'll do a post on this soon.

Part 3 here

Wyn

Excel MVP

www.accessanalytic.com.au