Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Dates | Excel Discussion (Misc queries) | |||
Filter dates in a pivot table | Excel Discussion (Misc queries) | |||
Dates in Pivot Table out of sequence - help | Excel Discussion (Misc queries) | |||
Pivot table dates not times | Excel Worksheet Functions | |||
Dates Formats in Pivot Table Help | Excel Worksheet Functions |