Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh
I am using excel 2007 to look at time series data via pivot tables. I am
importing the base data from a csv flat file into a sheet in excel -- that all works fine. I have then created a pivot based on the imported data sheet which has dates as the only enty in the Column Label. When I build the pivot initially all the dates are in the correct order from the oldest on the left to the newest on the furthest right. However when I update the underlying data sheet, by adding another months data and then refresh the pivot; the new dates are shown in a haphazard order on the pivot. If I rebuild the pivot from scratch its ok again -- but I want to be able to just refresh the pivot as I have built other analysis sheets off the back of it. Has anyone else experienced this or have an idea why it might be happening? -- Cormac |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh
Right Click on the Rogue Field and Select "Sort" and then "More Sort Options"
.... "Cormac Murphy" wrote: I am using excel 2007 to look at time series data via pivot tables. I am importing the base data from a csv flat file into a sheet in excel -- that all works fine. I have then created a pivot based on the imported data sheet which has dates as the only enty in the Column Label. When I build the pivot initially all the dates are in the correct order from the oldest on the left to the newest on the furthest right. However when I update the underlying data sheet, by adding another months data and then refresh the pivot; the new dates are shown in a haphazard order on the pivot. If I rebuild the pivot from scratch its ok again -- but I want to be able to just refresh the pivot as I have built other analysis sheets off the back of it. Has anyone else experienced this or have an idea why it might be happening? -- Cormac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping Dates in Excel 2007 Pivot Tables | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Using Order in Excel Pivot Tables | Excel Worksheet Functions | |||
Excel Pivot tables refresh | Excel Worksheet Functions | |||
Can you reformat order of items in Pivot Tables after refresh? | Excel Discussion (Misc queries) |