Excel Pivot Table Blank? Causes, Checks, and Fixes That Work

Charts & pivot tables · Updated November 18, 2026

If an Excel PivotTable is blank, first check its filters and source data, then refresh it and confirm that a field is in the Values area. A blank-looking report can also be caused by empty source cells, hidden values, or a PivotTable layout setting; the right fix depends on whether the whole report or only some cells are empty.

What “blank” can mean in a PivotTable

A PivotTable is a summary of records in a source range, Excel table, or other data source. “Blank” is not one specific error. It may mean there are no row labels, the body has labels but no numbers, some intersections contain no result, or a field appears as the item “(blank).” Those cases point to different causes.

Start by noting exactly what you see. If the entire report has disappeared, investigate the source and filters. If row and column labels remain but the values are missing, check the Values area and the source field’s contents. If only a few cells are empty, the underlying records may simply contain no value for those combinations.

One useful distinction: an empty PivotTable cell is not necessarily a zero. For example, if a report groups sales by region and product, a blank at West–Desk Lamp may mean no matching source records exist. A zero means a matching calculation produced zero. Replacing all empty cells with zero may therefore imply information that is not in the data.

Check the field layout first

Click anywhere in the PivotTable. Excel should display the PivotTable Fields pane. If it is not visible, use PivotTable Analyze > Field List. In the pane, fields can be placed in Filters, Columns, Rows, or Values. A report with fields only in Rows and Columns may show categories but no summarized figures.

For a basic sales summary, drag a field such as Region to Rows and Sales to Values. If Sales appears under Rows instead of Values, move it. If the Values area is empty, there is nothing for Excel to calculate in the body of the report. A PivotTable can still be useful for listing categories, but that is different from a numerical summary.

Also inspect the aggregation Excel selected. In the Values area, open the field’s dropdown and choose Value Field Settings. A numeric field is often summarized by Sum; a text field is generally counted. If the source field contains numbers stored as text or mostly empty cells, the result may not match expectations. Choose an appropriate summary, such as Count or Sum, based on what the source values actually represent.

Remove filters that exclude every record

A PivotTable can look empty when its filters leave no matching records. Check the dropdowns beside row and column labels, the Filters area above the report, and any slicers or timelines connected to it. A slicer can remain active even when its selection is easy to overlook. Clear filters temporarily to test whether data returns.

  • Open each visible PivotTable filter and select all items, or use Clear Filter where available.
  • Click each slicer’s Clear Filter button, usually shown as a small filter with a red X, and check timelines as well.
  • Inspect report filters in the Filters area of the PivotTable Fields pane.
  • Look for grouped categories or date periods that exclude the records you expect.

Filters can also hide only one part of a report. For example, a slicer set to “Online” may remove all store sales, while a date filter set to a month with no records can leave labels or a nearly empty body. Clearing filters is a diagnostic step; restore the intended selections once you know they were the cause.

Verify the source data and its range

A PivotTable summarizes its source; it does not automatically discover every unrelated row in the worksheet. If new records were pasted below the original source range, the PivotTable may still be using the old range. Select the PivotTable and choose PivotTable Analyze > Change Data Source to see or update the source. Check that the selected range includes the expected rows and all required columns.

For recurring data additions, convert the source range to an Excel table with Insert > Table, making sure the header row option is correct. A PivotTable based on a table can include rows added to that table when refreshed. This is generally more reliable than maintaining a fixed range, but it does not remove the need to refresh the PivotTable.

Inspect the source headers, too. Each column should have a distinct, nonblank header, and the data should form a consistent table rather than having title rows or blank separator rows mixed into the records. If an expected field is missing from the PivotTable Fields pane, check the source range and its header before rebuilding the report.

Refresh after changing the data

PivotTables may display a cached summary rather than immediately reflecting worksheet edits. After correcting or adding source records, click inside the PivotTable and select PivotTable Analyze > Refresh. To refresh multiple connections and PivotTables, use Data > Refresh All. A refresh updates the report from its current source; it will not fix a source range that excludes the new rows.

If refresh does not change the result, confirm that the edited cells are actually in the source and that the relevant filter is cleared. For a PivotTable based on an external connection or the Data Model, a refresh may also depend on access to that source and successful connection settings. A refresh error or unavailable source is different from a successful refresh that returns no matching records.

On Windows, the paths above apply to Excel for Microsoft 365. Excel for Mac has similar PivotTable and refresh controls, though ribbon labels and placement can vary by release. In Excel for the web, some PivotTable actions are available, but source changes and advanced layout or connection troubleshooting may require opening the workbook in desktop Excel.

Understand empty source cells and “(blank)”

If a source column has empty cells, Excel may show “(blank)” as a row or column item when that field is used to categorize records. This is a category for source records whose value in that field is empty; it does not mean the entire PivotTable has failed. You can filter that item out if it is not useful, or fill the missing source values if you can determine them accurately.

Empty cells in a Values field behave differently. Sum generally adds the numeric entries it can summarize, while Count counts nonempty entries. If a group has no numeric entries, a value may appear empty rather than as the zero you expected. Check the original records before changing the summary type or filling blanks. Replacing missing sales with zero, for example, is only appropriate if zero is genuinely what those missing entries mean.

To display text in empty result cells, click the PivotTable, open PivotTable Analyze > Options, and use the Layout & Format tab of the PivotTable Options dialog. The “For empty cells show” setting lets you enter a display value such as 0 or a short label. This changes how empty cells appear; it does not add records or change the underlying data. Use it only when that display is meaningful to readers.

Look for values hidden by formatting

If labels are visible but figures seem absent, select one of the apparently blank value cells and inspect the formula bar and number format. The value may be present but rendered invisible by white font, a custom number format, conditional formatting, or a column that is too narrow. Widen the column, temporarily apply a standard number format, and check the font and conditional-formatting rules.

Also check whether zero values are being suppressed. A report can contain zero but show a blank because of a number format or workbook display choice. That is not the same as an empty source cell. Compare the cell’s displayed result with the source records and the PivotTable’s summary settings before changing formatting across the whole report.

Be cautious when copying formatting from other cells: PivotTables can have their own styles, and refreshing or changing the layout can affect formatting. If the report is used repeatedly, adjust the PivotTable style or relevant number format and review the PivotTable Options settings that preserve formatting on update.

Use a quick diagnostic sequence

When the cause is unclear, work from the easiest checks to the more involved ones. This keeps you from changing the source unnecessarily or mistaking a legitimate empty result for a broken report.

  1. Click the PivotTable and confirm that the Fields pane shows the expected fields.
  2. Check that a measure or other field is in Values if the report should contain figures.
  3. Clear slicers, timelines, report filters, and row or column filters as a test.
  4. Refresh the PivotTable, then verify the source range includes the records you expect.
  5. Inspect source headers, blank cells, data types, and the specific records for an empty category.
  6. Check number formats, font color, conditional formatting, and column width if values may be hidden.
  7. Rebuild the PivotTable only after confirming the source and settings, or if its layout is damaged and simpler fixes fail.

For a concrete example, suppose a PivotTable lists North, South, and West but shows no sales totals. First confirm that Sales is in Values. If it is, clear the Region and date filters, then refresh. If the totals are still absent, check whether the source range contains the sales rows and whether the Sales column contains usable numeric values. If only West is empty, inspect West’s source records rather than assuming the whole PivotTable needs repair.

When rebuilding or changing the source is appropriate

Rebuilding can be reasonable if the PivotTable’s source headers changed substantially, the wrong source was selected at creation, or the field layout has become difficult to recover. Before deleting anything, preserve a copy of the workbook or create a new PivotTable on another worksheet. Compare the new report with the old one so you do not lose filters, grouping, formatting, or calculated settings that were important.

If the PivotTable uses the Data Model, Power Query, or an external database, investigate the upstream query or connection rather than assuming the worksheet range is its source. The visible report may be empty because the query returned no rows, the connection could not refresh, or a model relationship does not match the fields being combined. These cases can require checking the query, connection status, or model design.

Frequently Asked Questions

Why is my Excel PivotTable completely blank?
Common causes include filters that exclude all records, an incorrect or empty source range, a missing field in Values, or a source connection that returned no data. Clear filters, inspect the layout and source, then refresh.

Why does my PivotTable show row labels but no numbers?
Check whether a field is in the Values area. If one is, inspect its summary type and the source values; the field may be empty, stored as text, or filtered so that the relevant records are excluded.

How do I show zero instead of blank in a PivotTable?
Use PivotTable Analyze > Options, then the Layout & Format tab and “For empty cells show.” Enter 0 if a zero is a truthful display for the empty result. This changes presentation, not the source data.

Why does “(blank)” appear in my PivotTable?
At least one source record has an empty value in the field used for that row or column category. Filter out “(blank)” or correct the source only when you know the missing value.

Will refreshing fix a blank PivotTable?
It can update a report after source data changes, but it cannot correct a filter that excludes the data or a source range that omits it. Check those settings as well as the refresh result.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.