• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot does not re-sort after refresh

jecwobble

New Member
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?
 
Back
Top