If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|