If your pivot table is based on a large data source, it might respond very slowly when you add fields or move fields to a different area of the pivot table. To improve performance, try the following tips: Remove any pivot table styles and any other formatting, such as conditional formatting that you applied to [...]

Occasionally, you might need to change a column heading in the pivot table’s source data. For example, you could change a column heading from Qty to Quantity, to make it easier to understand. However, when you refresh the pivot table after making the changes, the renamed field will disappear from the pivot table layout. In [...]