I am using Excel 2011 for Mac. I have several pivots with dates as the values. I am sorting the row headings by those dates. When the dates in the source table change, and I refresh the pivot, the new date values appear, but the row headings remain in the same order as they were from the last date values. I have to manually re-sort on the date value field to get the rows to adjust. I don't recall having to do this in Excel for Windows. Is this a bug or am I missing something?