What happens when you check the Defer Layout Update option present in the PivotTable Fields window?
Vishalini.R Answered question July 1, 2023
Deferred layout update capability enables the pivot table component to be updated only when needed. When this feature is enabled, the end user can drag and drop fields between the row, column, value, and filter axes and apply sorting and filtering within the Field List, resulting in changes to the pivot report but not the pivot table data.
Vishalini.R Answered question July 1, 2023