Forum Discussion
Sorting table scrambles linked pivot table
I created a table (date, employee, location, pay) and then created a linked pivot table.
I then sort the table using the Filter buttons (say by date rather than location).
When I then refresh the pivot table the data is scrambled (ie employees appear in wrong locations).
However the data in the table itself is just sorted, not scrambled.
What am I doing wrong?
Excel for Mac v16.12
2 Replies
Well, haven't solved the problem but it's not in the pivot table...
The issue is a Match formula in one of the columns which stays stuck on the pre-sorting table layout.
Ok, solved the problem! I was using range data in the Match formula (ie AC14) instead of table references (ie [@LOCATION]).
Still don't really understand why ranges don't dynamically adapt, but table references work...
