Excel PivotTable Shows a Blank Row for One Month
Question details
The user needs to restore the individual transaction rows for a month that appears as a blank Description with only a monthly total in an Excel PivotTable.
- Product
- Microsoft Excel PivotTable
- Device & OS
- not provided
- Scenario
- A PivotTable displays transaction details for most months, but the July item appears collapsed or grouped into a single monthly total. The same behavior occurs on another device.
- Observed behavior
- July shows a blank Description and only a monthly total, while other months display individual bank transactions.
Click inside the affected PivotTable and identify the exact month and row or column field that contains July. Also confirm whether the source data includes July descriptions and consistent date or month values before changing the layout.
Expand the affected PivotTable field for July
Use this solution when the July item is collapsed and the PivotTable is hiding its underlying transaction rows.
A collapsed PivotTable item can display a subtotal or monthly total without showing the records beneath it. Expanding the July item restores its transaction-level entries without changing the source data.
Click inside the PivotTable, locate the July item in the month field, and right-click the July label.
Choose Expand/Collapse > Expand Entire Field from the right-click menu. If the menu is unavailable, select the PivotTable and open PivotTable Analyze > Expand Field.
With the PivotTable selected, open PivotTable Analyze and click Refresh to reload the expanded details from the source range.
Check July source values and refresh the PivotTable
Use this solution when expanding the field does not restore the rows or when July records may contain blank or inconsistent source values.
Work with PivotTables and Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight Microsoft Office alternative with a familiar spreadsheet interface and broad Excel file compatibility. Open compatible workbooks, review PivotTable layouts, and migrate your everyday spreadsheet work without a complex setup.
- 1. Install WPS Office: Download and open WPS Office, then launch WPS Spreadsheet from the home screen.
- 2. Open the workbook: Choose Open from the WPS Spreadsheet start page and select the Excel .xlsx or .xls workbook containing the PivotTable.
- 3. Review the PivotTable: Click the PivotTable and use the available field and refresh controls to inspect the month grouping and transaction details.
Frequently Asked Questions
Why does only July show a blank Description in the PivotTable?
July may be collapsed in the month or row field, so Excel displays its subtotal without the underlying transactions. The source Description cells for July may also be blank or inconsistent.
How do I expand all months in an Excel PivotTable?
Click any item in the affected field, right-click it, choose Expand/Collapse > Expand Entire Field, or select PivotTable Analyze > Expand Field while the PivotTable is active.
Will refreshing the PivotTable fix a collapsed July field?
Refreshing reloads source data but may not change a manually collapsed field. Expand the July item first, then use PivotTable Analyze > Refresh.
What should I check if July still shows no transaction details?
Use PivotTable Analyze > Change Data Source to identify the source range, then inspect July rows for blank descriptions, missing records, inconsistent dates, or values outside the selected range.
Can WPS Spreadsheet open an Excel PivotTable workbook?
WPS Spreadsheet can open and edit common Microsoft Excel .xlsx and .xls files. Compatibility may vary for advanced PivotTable features, so verify the layout and results after opening the workbook.
