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...
|