Forum Discussion
Getting this message: "This won't work because it would move cells in a table on your worksheet."
If your problem is related to a table produced from updating a query in power query, sometimes it helps if you cut and paste the table to sheet by itself. Then usually excel will let you update the table. Then you can paste the table back into your original sheet, which might have other items on it. It will now update fine in the original sheet. For some reason, sometimes that works, even though the table may not change in size.
I have seen this problem occur when there is no table below the table you are trying to update, even when the table you are updating does not change size.
The overall problem dealt with in this thread can be frustrating because several conditions can cause this problem.
This did not work for me - copying the information to a new sheet and pasting it in, I still get the same error when (in my case) I'm trying to copy down a value in a column to all cells in that column. It inserts 2 blank rows into the table and I get this error message. Very confusing what to do next.
This worked for me. I simply created a blank sheet, cut and pasted the columns with the table to the blank sheet, refreshed the query, and cut and pasted back.
