Excel Overlapping Pivot Table Error: How to Fix It

Charts & pivot tables · Updated November 19, 2026

Excel’s overlapping PivotTable error means a PivotTable is trying to occupy cells already used by another PivotTable on the same worksheet. Move one report to another location or worksheet, or make enough room between them, then refresh the report that failed.

What the overlapping PivotTable error means

The message commonly appears as “A PivotTable report cannot overlap another PivotTable report.” It is a layout conflict: Excel cannot place the refreshed or expanded output where it is scheduled to go because that area intersects another PivotTable. The problem concerns the reports’ locations on the worksheet, not necessarily the data they summarize.

A PivotTable is not a static block of values. Its displayed size depends on its fields, the items in those fields, and its layout. For example, a report with Department in Rows and Month in Columns may grow when new departments or months appear in the source data. If another PivotTable sits directly below or beside it, a refresh can make the first report run into the second.

The error does not normally mean that two PivotTables use the same source data or share a PivotCache. Excel can have multiple PivotTables based on the same data. They simply need separate output areas on a worksheet. The source range can also overlap another data range without causing this particular report-layout conflict.

Why a PivotTable starts overlapping after refresh

A report that worked yesterday can fail after a refresh because its shape changed or another report was moved into its path. Common triggers include:

  • New row or column items: New products, regions, dates, or categories in the source can add labels to the PivotTable.
  • More fields in the layout: Adding a field to Rows, Columns, or Values can make the output taller or wider.
  • A change in report layout: Switching between compact, outline, or tabular presentation can change how fields use worksheet columns.
  • Filters changed: Clearing a filter can expose more items; changing a report filter may also change the visible report.
  • A neighboring report was enlarged: Refreshing another PivotTable first may have caused that report to occupy cells the first one needs.
  • Manual edits around the report: Moving, copying, or rearranging worksheet content can leave PivotTables too close together.

For instance, suppose a sales PivotTable begins in A3 and a second one begins in A20. If the first report gains several product rows after refresh, it may reach row 20. Excel then cannot place both reports in the requested cells. The source data may be completely valid; the conflict is the space reserved for the results.

How to find the conflicting report

Start by noting which PivotTable you refreshed and where its upper-left corner is. The other report is usually nearby, but it may be to the right rather than directly underneath. Check both directions, especially if the first PivotTable has multiple column fields or many row items.

  1. Dismiss the error message without deleting worksheet content.
  2. Click inside the PivotTable that you were trying to refresh. Use PivotTable Analyze > Select > Entire PivotTable to identify its current footprint, if that command is available in your ribbon layout.
  3. Look immediately below and to the right of the report for another PivotTable. Click suspected reports and check whether the PivotTable Analyze tab appears.
  4. Consider how much the refreshed report may grow. A report that currently ends at row 18 may need more rows when new categories arrive.
  5. If the conflict is not obvious, move one PivotTable temporarily to a new worksheet, then refresh. This can confirm that the issue was a collision between report locations.

Do not rely only on visible labels to estimate a report’s future size. Filters can hide items, and a refresh may reveal new categories. Also, text or numbers sitting in the way can cause a different warning when a PivotTable tries to expand. If Excel says that cells will be overwritten rather than that PivotTables overlap, inspect the affected cells before clearing them.

Fix 1: Move a PivotTable to another worksheet

Putting each substantial report on its own worksheet is the most dependable fix when the reports serve different purposes or grow unpredictably. It gives each PivotTable room to expand and makes the workbook easier to navigate.

  1. Click a cell inside the PivotTable you want to move.
  2. Choose PivotTable Analyze > Move PivotTable.
  3. In the dialog, choose New Worksheet, or choose Existing Worksheet and specify a destination cell with enough open space.
  4. Select OK, then refresh the PivotTable again if needed.

Moving the report does not change its source data, but check the new sheet after moving it. Review its filters, formatting, and nearby charts or notes, since a move can affect how the report fits into a workbook designed around its original location. On Mac, Excel also provides PivotTable analysis commands when a PivotTable is selected, though ribbon organization and labels can vary by release. If you do not see the command, use Excel’s ribbon search to look for “Move PivotTable.”

Fix 2: Make a clear buffer between reports

If both reports need to stay on one sheet, move one far enough away that the other can grow without reaching it. For example, place the second report several rows below the first and leave a few empty columns between reports that may expand sideways. There is no universal safe number of rows: a monthly report, a list of products, and a report with nested row fields can all grow at different rates.

To reposition a report, select it and use PivotTable Analyze > Move PivotTable, choosing Existing Worksheet and a new upper-left destination cell. This is safer than cutting and pasting a few visible cells, because a PivotTable is a structured report rather than an ordinary range. After moving it, refresh and confirm that the output fits without touching neighboring content.

Simply inserting blank rows between two PivotTables may not solve the problem if the first one continues to grow. A practical buffer should account for plausible future categories, not just the current display. If the underlying data changes regularly, separate worksheets are usually easier to maintain than repeatedly widening that buffer.

Fix 3: Reduce the PivotTable’s footprint

Sometimes a report can stay in place if you reduce the area it uses. Review the field list and remove fields that are not necessary for the report’s purpose. A field in Rows can create many additional lines; a field in Columns can add many columns. Moving a field from Rows to Filters, or removing an unused field, may shrink the output, but make sure the change still answers the intended question.

Filters can limit which items appear, but they are not always a lasting space guarantee. A future user can change a filter, or new source items can appear. Likewise, hiding worksheet rows or columns does not create a separate safe area for a PivotTable: hidden cells still belong to the worksheet grid and can still be occupied by a report.

Changing the report layout can affect its shape, but it should be done for readability rather than as a blind workaround. Before changing fields or layout, consider making a copy of the worksheet or noting the original arrangement. That makes it easier to restore the report if the new layout obscures comparisons or makes totals harder to interpret.

Refresh carefully and protect the surrounding layout

Once the reports have separate space, refresh the affected PivotTable by clicking inside it and choosing PivotTable Analyze > Refresh. To update multiple connections and reports, Data > Refresh All is available, but refreshing everything can expose layout issues in other PivotTables too. If the workbook contains many reports, refreshing them individually can help identify which one changes size unexpectedly.

Before a large refresh, save the workbook. Refreshing updates PivotTable results from their source; it is not a substitute for preserving a prior workbook state. After refreshing, check whether new labels, totals, or columns have appeared and whether they fit the space allocated. If a refresh fails again, do not repeatedly delete nearby cells: first confirm whether the message identifies another PivotTable or ordinary content.

For recurring reports, give PivotTables predictable locations and document their purpose. A simple dashboard might place a summary at the top of one sheet and details on separate sheets. If reports must share a sheet, leave generous room and avoid placing manually maintained notes immediately beside an area expected to expand.

Related errors and common misconceptions

Several Excel issues can look similar but have different causes. “A PivotTable report cannot overlap another PivotTable report” points to two PivotTable output areas competing for cells. A warning that PivotTable cells will be overwritten points to existing worksheet content in the expansion area. A refresh or connection error may instead indicate a source, permission, or connection problem. Read the wording carefully before changing the layout.

It is also easy to confuse the PivotTable with its source. An Excel Table used as the source can sit on the same sheet as a PivotTable if their actual cells do not collide; the source data does not have to be moved merely because it feeds the report. Similarly, two PivotTables can summarize the same table and still work normally when their displayed areas are separate.

Protecting a worksheet, merged cells, or unavailable source data can cause other Excel problems, but they are not the usual explanation for the specific overlap message. If moving the report does not resolve the error, verify that you moved the entire PivotTable, refresh the correct report, and read any new message rather than assuming every PivotTable failure has the same cause.

Frequently Asked Questions

How do I fix “A PivotTable report cannot overlap another PivotTable report”?
Move one of the PivotTables to a new worksheet or to a clear area with room for it to expand. Use PivotTable Analyze > Move PivotTable, then refresh the report.

Can two PivotTables use the same source data?
Yes. Multiple PivotTables can summarize the same source data. The overlap error concerns where their results appear on the worksheet, not whether their source ranges are shared.

Why did my PivotTable overlap another one after refreshing?
The refresh may have added categories or columns, or a field or filter change may have enlarged the report. The second PivotTable was placed too close to the space the first one now needs.

Will hiding rows or columns stop the overlap?
No. Hidden rows and columns are still part of the worksheet grid. Move a PivotTable or give it more physical space instead of hiding cells as a workaround.

Should I delete the other PivotTable?
Only if you no longer need it. Usually, moving one report is safer and preserves its analysis. Deleting a PivotTable does not delete its source data, but it removes that report from the sheet.

Why does Excel mention cells being overwritten instead?
That usually means the PivotTable is trying to expand into ordinary worksheet content, not another PivotTable. Inspect the cells Excel identifies and move the report or relocate the content before clearing anything.

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.