Queries & Connections "This wont becuase it would move cells in a table on your worksheet" error

Occasional Visitor

Working in excel 2016, and trying to set up a database to track FPY.

We have set up individual user sheets for 10 different production lines, and then used GetData to pull each of these sheets into a master sheet.

This allows us to sort and manipulate this data in mass, and each user can be in their sheet without locking other users out.

 

The issue I am having is, when I open the document and all of the tables refresh to pull in updated date, I get the error "This wont work because it would move cells in a table on your worksheet".

 

What I don't understand is, this worked just a week ago. 

Tables would refresh with new data, all tables would expand as needed, and push the tables below it down if needed. Now all of a sudden its not working.

 

Capture.PNG

0 Replies