Pivot Table Dates
 

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

Pivot Table Dates
 

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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Dates
 

On Mar 17, 5:01 pm, Debra Dalgleish wrote:
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 wrote:
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
Contextureshttp://www.contextures.com/tiptech.html

Yes. All are using the same language and regional settings

Pivot Table Dates
 

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?

denhamlee wrote:
On Mar 17, 5:01 pm, Debra Dalgleish wrote:

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 wrote:

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
Contextureshttp://www.contextures.com/tiptech.html


Yes. All are using the same language and regional settings



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html