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.