record a macro to update pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What version of Excel are you using, and what does your recorded code look
like?
On which line of code does it show the error message?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table 1
One pivot table cannot overlap another pivot issue. 1
Macro for auto refresh 1
Pivot Table update 8
Pivot table report invalid 0
How do I save Pivot Table Data 4
Pivot table not sorting 2
Pivot table drill down data 2

Back
Top