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.
