When an Excel pivot table is not displaying data, the workbook usually has one of four problems: the PivotTable cache is stale, the source range no longer covers the real table, a filter is hiding the records, or fields were removed from the layout. The fastest fix is to refresh first, then inspect the Field List and source range before rebuilding anything. A blank PivotTable can look like corruption, but most cases are a layout or connection issue.
Refresh the Excel PivotTable data
Refresh current cached PivotTable records
Click anywhere inside the PivotTable, then use PivotTable Analyze >> Refresh. If the workbook has several PivotTables that share the same source, use Refresh All from the Data tab so each cache updates together. This matters when the source table changed after the PivotTable was created, because the report can keep showing the old snapshot until you refresh it. The catch is that refresh will not fix a source range that excludes new rows, so treat this as the first test rather than the whole repair.
My usual tell is a PivotTable total that ignores yesterday’s rows while the source table clearly contains them.
Confirm fields are still visible
If the PivotTable area is empty but the shell of the report still exists, right-click inside it and choose Show Field List. In newer Excel builds, you can also select the PivotTable and use PivotTable Analyze >> Field List. Drag at least one text field into Rows and one numeric field into Values so Excel has something to summarize. If fields are missing from the list, refresh again; Microsoft notes that newly added fields may not appear until the PivotTable is refreshed.
A common mistake is moving every field out of the layout while trying to simplify the report. The PivotTable is still valid, but it has no visible rows or values to display. Put the key fields back before changing the data source.
Remove filters hiding valid records
Look for dropdown arrows on row labels, column labels, report filters, and slicers. Clear any filter that limits the report to blank items, old categories, or a period with no matching records. When a PivotTable says there are no items to show, filters are often more likely than file damage. If the workbook uses slicers, select the slicer and use Clear Filter so it releases every connected PivotTable.
- Check report filters at the top of the PivotTable before editing formulas or source data.
- Clear slicers connected to the report, because they can filter a PivotTable even when the field area looks clean.
- Inspect date grouping, especially when the source has real dates mixed with text dates or blanks.
Repair source data and layout
Expand the current source range
Select the PivotTable and use PivotTable Analyze >> Change Data Source. Confirm the range includes the full source table, including new rows and columns. If the range points to a fixed block such as A1:H500, convert the data to an Excel Table with Insert >> Table, then point the PivotTable to the table name. That prevents the same missing-row problem the next time the source grows.
This is also the right moment to check the source headers. PivotTables need consistent column names; blank or duplicated headers can make fields disappear or summarize badly. Fix headers in the source, refresh, and then place the fields again.
Fix blank values and wrong types
A PivotTable can display blanks when the source uses formulas returning empty text, numbers stored as text, or hidden rows that look like available data. Use a small filter on the source table to find blanks in important columns. If numbers are stored as text, convert them before refreshing so Excel can place the field in Values instead of treating it like a row label. For date fields, standardize the date format and avoid mixing typed dates with pasted text.
For related workbook stability checks, stop Excel freezing before you rebuild a large report. That keeps the troubleshooting focused on the PivotTable rather than a slow workbook.
Recreate only after targeted checks
If refresh, filters, fields, and source range all look correct, create a test PivotTable from the same source on a new worksheet. This separates a damaged PivotTable layout from a bad source. If the test report works, delete the broken report and rebuild it from the same table. If the test report also fails, the source data needs cleaning or the workbook needs repair.
When the whole workbook feels unstable, repair slow workbook behavior before assuming the PivotTable cache is the only issue. Large formulas, conditional formatting, and external links can make PivotTable refresh appear broken.
Edge cases that still matter
External connections need separate checks
PivotTables connected to Power Query, databases, or external files can fail because credentials, paths, or privacy settings changed. Use Data >> Queries & Connections and refresh the query directly. If the query fails, fix that error first; the PivotTable cannot display data it never receives. For network files, copy the workbook and source locally to rule out a sync or permission problem.
Manual update delays layout changes
The PivotTable Field List can be set to defer layout updates. If you dragged fields into areas and nothing changed, look for Defer Layout Update near the bottom of the Field List and click Update. This setting is useful for big models but confusing during troubleshooting because the report waits instead of reacting immediately.
Corrupt files need workbook repair
If Excel crashes during refresh, shows unreadable content warnings, or refuses to save after PivotTable changes, use File >> Open >> Open and Repair on a copy of the workbook. Repair is a workbook-level step, not a PivotTable setting. Keep the original file untouched until you know the repaired copy opens and the source data is intact.
Excel questions answered
Why is my PivotTable showing blank data?
The most common reasons are stale cached data, filters that hide all records, fields removed from the layout, or a source range that no longer includes the real table. Refresh first, then check the Field List and filters before rebuilding the PivotTable.
Why are new rows missing from my PivotTable?
New rows are usually missing because the PivotTable still points to an old fixed range. Change the data source to include the full range or convert the source into an Excel Table so future rows are included automatically.
Can a PivotTable break if source headers change?
Yes. Renamed, blank, or duplicated headers can make fields disappear or behave like new fields. Fix the source headers, refresh the PivotTable, and place the corrected fields back into the layout.
Most blank PivotTables are fixable without rebuilding the workbook. Refresh the cache, restore the fields, clear filters, and only then change the source or create a clean replacement report.