Pivot Table Global Options

Overview

There are over two dozen options which control everything from how your pivot table refreshes, to how it prints, to how you want things displayed.

If you right click anywhere in the pivot table area:

Choose the Pivot Table Options:

There are two options that we wish to call to your attention

1. UNCHECK ‘Autofit column widths on update'
2. CHECK ‘Preserve cell formatting on update’, as shown above.