ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   order of months in pivot table (https://www.excelbanter.com/excel-worksheet-functions/446831-order-months-pivot-table.html)

Rajesh Bhapkar

order of months in pivot table
 
Dear all,

I have created a pivot table based on the information in sheet1. The row headings contain the month in MMM format (Jun, Jul, aug, sep...and so on).
This excel sheet is uploaded on sharepoint, where everyone can check the pivot table.

The users at my location can see the months in order.... However the users at other locations (overseas clients) get the view of months in alphabetical order (Aug, Dec, Jul, Nov, Oct, Sep).

I have already formatted the pivot table to sort the row headings in order of months and as mentioned all users at my location can view the correct order... But how can i lock the formatting or what can i do so that it is viewed in the same order for every user...


All times are GMT +1. The time now is 07:48 PM.

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