Getting this message: "This won't work because it would move cells in a table on your worksheet."

I was getting the same error message because I had accidentally chosen the entire columns to be part of the table. I was able to fix by going into Design > Resize Table and selecting the proper range of data.