Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables 2003 v 2007
So I have an odd question.. I have a pivot table (created in Excel 2003) that
links to data (also created in Excel 2003). This Pivot Table has a report filter that allows me to select dates. Right now I do not have the "all" selected in this report filter but actually have the days selected. When I add new data to the data.xls and refresh my pivot table it automatically adds the new dates and selects them automatically to show up in my Pivot table results... This is what I want to happen. Now, I also have a pivot table (created in Excel 2007) that links to the same data (created in Excel 2003) from before. When I add new data and refresh the Excel 2007 Pivot table it adds the new dates but does NOT automatically select them to include in my pivot results. I have search all over but cannot find the setting that controls this Anyone know why this would be? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use the old 2003 pivot tables in excel 2007? | Excel Discussion (Misc queries) | |||
Pivot tables 2007 to 2003 | Excel Discussion (Misc queries) | |||
2007 pivot tables on 2003 | Setting up and Configuration of Excel | |||
2007 pivot tables in 2003 | Excel Discussion (Misc queries) | |||
Macros / VBA / Pivot Tables in 2003 & 2007 | Setting up and Configuration of Excel |