Fix the Excel Error: A PivotTable Report Cannot Overlap a Table
Question details
The user needs to resolve an Excel PivotTable overlap error when adding a date field to Rows.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Adding a date field to the Rows area of a PivotTable and grouping the dates.
- Observed behavior
- Excel reports that the PivotTable cannot overlap a table. Date grouping labels may disappear, and the date field may no longer be available for grouping.
Identify the PivotTable's source data and check whether an Excel table or other data occupies the report's current or intended location. Make sure the source date column contains valid dates before attempting to group it.
Move the PivotTable to an Empty Worksheet
Use a blank worksheet to give the PivotTable room to expand without overlapping an Excel table or other data.
Click the plus button next to the worksheet tabs to create a new, empty sheet.
Click inside the PivotTable, then select PivotTable Analyze > Move PivotTable. Choose the new worksheet and an empty destination cell, then click OK.
In the PivotTable Fields pane, drag the date field to Rows. If you need date grouping, right-click a date in the report and select Group.

Rebuild the PivotTable from Data Copied to a New Sheet
Try a fresh layout if moving the report does not clear the error.
Work with PivotTables in WPS Spreadsheets
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files and continue working with your data as you migrate between office suites. It does not repair Excel's overlap error.

Frequently Asked Questions
Why does Excel say my PivotTable cannot overlap a table?
The PivotTable may need to expand into an area occupied by an Excel table. Move it with PivotTable Analyze > Move PivotTable or create it on a new, empty worksheet.
How do I move an existing PivotTable to another sheet?
Click inside the PivotTable, choose PivotTable Analyze > Move PivotTable, and select an empty destination on another worksheet.
Why can't I group the dates in my PivotTable?
Check the source date column for blanks or values that Excel does not recognize as dates, then refresh the PivotTable using PivotTable Analyze > Refresh. Grouping may also be unavailable for some data sources.
What should I try if the error occurs on a new worksheet?
Restart Excel and try again. If the error continues, copy the source data to a new worksheet or workbook and create a fresh PivotTable using Insert > PivotTable.




