Pivot Table Global Options | CLEARIFY

Global Options to Control Behavior

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:  UNCHECK ‘Autofit column widths on update' and CHECK ‘Preserve cell formatting on update’, as shown above.