I have a pivot table and want to record a macro that refreshes and then sorts
in descending order.
When i do this i keep getting error 1004

Any ideas where i have gone wrong
Is is there another way to refresh and automatically sort