btadams
Well-known Member
- Joined
- Jan 6, 2003
- Messages
- 1,943
In a pivot table when click on the Row Labels or Column Labels drop-down you can go to More Sort Options -> More Options and uncheck the Sort Automatically every time Report is Updated. What exactly does this do? I have a pivot table I've manually sorted and I don't want it to change when the pivot table is refreshed. Will this option do that or does it just stop sorting when the underlying data table is updated? Also does anyone know what the VBA code is to set this option to False? I tried using the macro recorder but it didn't give me anything.
Thanks,
BTAdams
Thanks,
BTAdams