Common Pivot Table questions usually involve refresh behavior, field settings, and display results; this section includes 4 practical questions and a glossary.
FAQ
What should I do if the Pivot Table does not change after the source data is updated?
- Confirm that the updated records are included in the source data range.
- Check whether the Pivot Table is still linked to the old range.
- If needed, use Change Data Source to select the correct range.
- Refresh or review the Pivot Table again.
Why does the values area show the wrong type of summary?
- Select the field in the values area.
- Open Value Field Settings.
- Check whether the current summary method is Sum, Count, Average, or another option.
- Click OK and review the updated result.
What should I do if a slicer does not filter the report as expected?
- Confirm that the slicer is connected to the correct field.
- Check whether the source data contains distinct values for that field.
- Select different slicer items and see whether the Pivot Table changes.
- If needed, insert the slicer again and choose another field.
How do I return to the original layout after grouping items?
- Select the grouped Pivot Table.
- Open the Analyze tab.
- Click Ungroup.
- Check whether the original item structure returns.
Glossary
| Term | Definition |
|---|---|
| Pivot Table | An interactive spreadsheet tool used to summarize, analyze, and present data from different dimensions. |
| Value Field Settings | The settings panel used to change how values are summarized, such as Sum, Count, or Average. |
| Slicer | A visual filtering control that helps you filter Pivot Table results quickly. |
| Fields and Items | A Pivot Table tool area used for calculated fields, calculated items, solve order, and formula listing. |