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 p...
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...