Forum Discussion
laura_protzman
Jan 07, 2019Copper Contributor
Getting this message: "This won't work because it would move cells in a table on your worksheet."
When I try to insert a row in a formatted table, I get the following message: "This won't work because it would move cells in a table on your worksheet."
Ken_Rose
May 28, 2019Copper Contributor
laura_protzman I had a similar message when I tried to refresh a table created with Power Query based on reading a table of data from a source file. Turns out that I had added a few rows to the source file and so the query couldn't place the newly-expanded table of data into the confines of the existing table. Once I manually added rows to the "receiving" table (by dragging the small, square fill handle in the lower right corner of the lower-rightmost cell in the table down to add as many rows as needed), the query was able to run again.