Excel 2007 Pivot Table Dates Out Of Order

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

tomt66

Thread Starter
Joined
Jan 4, 2013
Messages
2
In the PT date list, 5/30/13 appeared after 7/31/13 in the column. Checked the source data and found that it was correctly formatted as 'dates'. The only thing I could do to get the May date to appear before the July date was to first change the source data formatting to 'General', which converted the dates to 5-digit numbers. When I refreshed the PT, 5/30/13 appeared before 7/31/13. Changing the source data back to date format and refreshing again put 5/30/13 after 7/31/13. This only happens to one date in the list, 5/30/13, i.e., the other dates are in the proper order each time I refresh. Any idea what's happening here? Thanks! Needless to say, it's a pain to have to do this workaround to get the PT to properly order the dates.
 
Joined
Jan 13, 2009
Messages
38
Hi tomt66, can you post something that exhibits the same behavior? Maybe take the spreadsheet you're working on, and blanking out everything except the dates and build that pivot table where the 5/30/13 is appearing after 7/31/13.
 

tomt66

Thread Starter
Joined
Jan 4, 2013
Messages
2
Hi tomt66, can you post something that exhibits the same behavior? Maybe take the spreadsheet you're working on, and blanking out everything except the dates and build that pivot table where the 5/30/13 is appearing after 7/31/13.
Thanks Center! I'll see if I can post a stripped-down spreadsheet on Monday that exhibits this behavior. Appreciate your interest.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top