Editing worksheets > Pivot tables > Configuring pivot tables with the field list

At the bottom of the field list you will find the option Defer layout update. It is combined with the Update button on the right, but is not related to the Refresh data option (see Updating pivot tables and changing data range).

When you are repositioning fields in the field list, for example, add/remove/move fields in the areas section, the pivot table report is recalculated each time. This can take quite some time with large reports. Therefore, if you want to temporarily disable continuous recalculation, please proceed as follows:

1.	Place a check mark in the Defer layout update checkbox. You can then rearrange the fields of your pivot table, but you will not see the resulting changes in the pivot table report. In addition, all other editing options for this state are disabled.

2.	Once you have finished repositioning the fields, click the Update button to see the result of the change.

3.	Remove the check mark from the Defer layout update checkbox.

Note: If you disable the Defer layout update option again without pressing Update, all arrangements of the fields that you have made since the option was enabled will be discarded.