Pivot Table Global Options

Modified on Sun, 26 Jul at 4:05 AM

Overview

Excel provides more than two dozen PivotTable options that control refresh behavior, formatting, printing, and display.

For QQube reports, two formatting options are especially important because they determine whether your column widths and cell formatting are preserved when the PivotTable refreshes.

Open PivotTable Options

1. Open the PivotTable Menu

Right-click anywhere inside the PivotTable.

Excel PivotTable right-click menu

2. Select PivotTable Options

Select PivotTable Options.

Excel PivotTable Options window showing layout and formatting settings

Recommended Formatting Settings

Clear Autofit Column Widths on Update

Setting: Unchecked

This prevents Excel from automatically changing your column widths each time the PivotTable refreshes.

Select Preserve Cell Formatting on Update

Setting: Checked

This preserves your fonts, number formats, borders, fills, and other cell formatting when the PivotTable refreshes.

Expected Result

After these settings are applied, refreshing the PivotTable will not resize the columns or remove your custom cell formatting.