| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable contains last month's dates
Hi,
I've got a PivotTable report which is run on a monthly basis. The source data is coped into the workbook and the data/charts refreshed. The correct data (and date range) is being shown in the report, but the date field on the X axis shows dates from both June and July as selectable. How can I prevent last month's dates being shown? Thanks in advance for your help... Best regards, Kevin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
PivotTable contains last month's dates
To clear old items from the pivot table, you can use one of the
techniques shown he http://www.contextures.com/xlPivot04.html wrote: Hi, I've got a PivotTable report which is run on a monthly basis. The source data is coped into the workbook and the data/charts refreshed. The correct data (and date range) is being shown in the report, but the date field on the X axis shows dates from both June and July as selectable. How can I prevent last month's dates being shown? Thanks in advance for your help... Best regards, Kevin -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manipulating dates (was Add 6 months to a date) | New Users to Excel | |||
| How do I find the length of time (Years & Months) between 2 dates | Excel Worksheet Functions | |||
| how do i sort dates by months and not years? | New Users to Excel | |||
| Calculating Dates in Terms of Months | Excel Worksheet Functions | |||
| Converting Text months to sortable Numbers or Dates | Excel Discussion (Misc queries) | |||
Linear Mode
