I have a workbook that has multiple pivot tables calculating a % of compliance based on rows of data. Every time I update the rows of data and refresh the pivot tables the % of compliance will change. I want the pivot tables to be sorted from smallest % to largest %. Currently, I have click on every pivot table and put it in sort order every time the workbook is refreshed.
Is there a way to set the pivot tables to ALWAYS sort the value A to Z when being refreshed?