Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables in XL 07
I just updated a pivot table in XL 07 and noticed something strange.
I have the months of the year broken out horizontally, starting with Jan on the left and Jul on the right: Jan, Feb, Mar, Apr, May, Jun, Jul. I just updated the pivot table with data for Aug and the pivot table updated itself like this: Aug, Jan, Feb, Mar, Apr, May, Jun, Jul I realize I can just drag the Aug column to its proper place to the right of Jul, however is there some setting that will automatically force Excel to use the correct month progression? This pivot table has always been maintained in XL 07 and this is the first time I've seen this behavior. Thanks. Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |