MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table

Posted by Paul on July 19, 2001 8:20 AM

I have a pivot table in a workbook, sheet name “pivot table” and have the code below in it, this refreshes the table when the sheet tab is clicked on, but I also want to resort column A in ascending order when the pivot table sheet is clicked on, is there some code that can be added to do this? Thanks for your help in advance. Paul

Posted by Mark W. on July 19, 2001 8:46 AM

No code needed! Just double-click the field
button that you want sorted, press the
[ Advanced... ] button, set the AutoSort options
to "Ascending", and press [ OK ] each time you're