ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Dates (https://www.excelbanter.com/excel-discussion-misc-queries/135552-pivot-table-dates.html)

denhamlee

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? The data
is being pulled from a database and is being updated hour by hour,
etc. thanks.
dl



All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com