Pivot Table Dates

[denhamlee]

I have made a pivot table. Works great. I have grouped a date field
(Year, Month, Days) and that works fine as well. I did not check the
'Auto starting at and ending at check boxed. When I look at the
spreadsheet my 'Day' field lists chronoligically. I am networked with
co-workers who use the same spreadsheet. The spreadsheet is on a
shared drive so we all work from the same application. The issue is
that when they open it their 'Day' list does not start
chronoligically
but somewhere in the middle. How can I get it so that whoever opens
the application the day list will be listed chronologically? thanks.
dl

 

[Debra Dalgleish]

What does the list of dates look like, e.g.
1-Jan
2-Jan

Do you all use the same language and regional settings?

 

[denhamlee]

What does the list of dates look like, e.g.
1-Jan
2-Jan

Do you all use the same language and regional settings?

Yes. All are using the same language and regional settings

 

[Debra Dalgleish]

And what does the list of dates look like, e.g.
1-Jan
2-Jan
Does everyone's list look the same, except for the order of dates?