I have a simple Pivot Table with just two columns, a label and a total count of entries. The first time I ran the Pivot Table the labels were sorted alphabetically, which is what I wanted. I made some changes to the source data table labels, and then refreshed the Pivot Table. But the labels that were edited (mostly different spellings) now appear at the bottom of the first column of the Pivot Table. Is there a way I can restore alphabetical sorting in refreshed Pivot Tables?
I am using Excel for Mac 2011 on a Macbook Pro.
Thank you.
Bookmarks