| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Pivot Table Date Range
Hi,
I have about 50 pivot tables that shows a rolling 12 month period. After I refresh each month I want to drop off the 13th month. How can I do this without having to go to each table and deselect the latest month? Any help is appreciated thanks!! i.e. february 2007 to february 2006 - With all the months in - between. After refresh - March 2007 to February 2006 - I don't want to display the Feb 2006 Thanks You!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Date Range | Excel Discussion (Misc queries) | |||
| Pivot Table - Count only within date range | Excel Discussion (Misc queries) | |||
| Dynamic Range in a Pivot Table | Excel Discussion (Misc queries) | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Setting Range in Pivot Table | Charts and Charting in Excel | |||
Threaded Mode
