Power Query Problems

Fix Power Query Cannot Move Cells in an Excel Table Error

John Wilson Oct 16, 2026 870 views

Question details

Users encounter an error stating Excel cannot move cells when attempting to refresh, insert, or expand a Power Query table.

How to Fix the Cannot Move Cells in an Excel Table Error in Power Query

Product: Excel
Device & OS: not provided
Scenario: Refreshing or adding rows/columns to a Power Query table on a worksheet that contains multiple tables or data objects.
Observed behavior: Excel blocks the query refresh or expansion and displays an error message because expanding the query table would overwrite, push, or damage an adjacent table on the same worksheet.

Before you start

Before adjusting your table layouts, carefully inspect your entire worksheet—including columns and rows beyond the immediately visible data—to locate any hidden tables or objects that might be blocking the query expansion.

Solution 1Recommended

Relocate or Resize Adjacent Tables

Move other tables out of the path of the Power Query table so it has enough empty space to expand rows and columns during a data refresh.

This error is a design limitation in Excel. When a row or column is added to a Power Query table, Excel attempts to insert cells across the worksheet. If another table is positioned too closely (for example, extending into the same row or column bands), Excel prevents the movement to avoid corrupting the second table.

Identify overlapping ranges

Scroll through your worksheet to locate any secondary tables situated below or to the right of your main Power Query table.

Select the blocking table

Click and drag to select the entire range of the adjacent table that is in the path of the query expansion.

Move the table

Hover over the border of the selected table until your cursor becomes a four-sided arrow, then click and drag the table to a new location with plenty of buffer space.

Check Column Limits: Ensure that your Power Query table does not share intersecting column or row coordinates with other tables that have a different maximum column width, as this triggers the insertion conflict.

Solution 2

Load the Query to a Dedicated Worksheet

Prevent layout conflicts entirely by directing the Power Query output to its own independent worksheet.

Free Microsoft Office alternative

Manage Your Spreadsheets Seamlessly with WPS Office

If you frequently encounter complex table formatting errors and query limitations in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible, lightweight, and user-friendly alternative for managing large datasets and formatting tables without unexpected overlapping errors.

1. Download and install WPS Office: Visit the official WPS website to download and install the free suite on your device.
2. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx files without losing any data.
3. Organize your data easily: Use the clean, tabbed interface to manage multiple tables efficiently across separate worksheets.

Fully compatible with Microsoft Excel (.xlsx) file formatsLightweight application that runs fast, even with large datasetsFree alternative to Microsoft Office for everyday data tasksIntuitive spreadsheet interface for seamless table management

Frequently Asked Questions

Why does Excel say it cannot move cells when refreshing a Power Query?

This happens because refreshing the query attempts to add rows or columns to its table, which forces existing cells to shift. If another table is in the direct path of these shifting cells, Excel blocks the action to prevent data overlapping and corruption.

Can I have multiple Power Query tables on the same worksheet?

Yes, but you must ensure they are placed with enough empty columns and rows between them. They should be arranged so that inserting new rows in one table does not intersect with the column boundaries of the other.

How do I find hidden tables causing the move cells error?

Go to the Formulas tab and click on 'Name Manager'. This will list all named ranges and tables in your workbook, allowing you to easily locate and navigate to tables that might be hidden far to the right or bottom of your worksheet.

Excel & Data Problems