ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/186653-pivot-table-formatting.html)

rciolkosz

Pivot Table Formatting
 
My pivot table has columns 1 - 10. The table on my computer is in order 1 -
10, but when I send it to others, the 10 follows the 1 out of order. I
unchecked auto format. Why does it lose the ascending order when I send it
to others?


Debra Dalgleish

Pivot Table Formatting
 
Do you have a custom list on your computer, that sorts these items?
To check, choose ToolsOptionsCusotm Lists

rciolkosz wrote:
My pivot table has columns 1 - 10. The table on my computer is in order 1 -
10, but when I send it to others, the 10 follows the 1 out of order. I
unchecked auto format. Why does it lose the ascending order when I send it
to others?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 12:07 AM.

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