| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refresh in pivottable
I have a problem during refresh in my pivot table. In one of the Pivot field called 'Category', I have the following list of values: A, B,C,D,E and F. My base table data has changed for this month and category C and E don't have any occurences
After refresh , values C and E are still out there in the pivot field. How do I get rid of them? I don't want to manually hide them or delete them Please help thank Kanan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refresh in pivottable
Hi
have a look at http://www.contextures.com/xlPivot04.html -- Regards Frank Kabel Frankfurt, Germany "Kanan" schrieb im Newsbeitrag ... I have a problem during refresh in my pivot table. In one of the Pivot field called 'Category', I have the following list of values: A, B,C,D,E and F. My base table data has changed for this month and category C and E don't have any occurences. After refresh , values C and E are still out there in the pivot field. How do I get rid of them? I don't want to manually hide them or delete them. Please help thanks Kanan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refresh in pivottable
thanks for the info
kanan |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
refresh in pivottable
Hi
Thanks for the info. Iam still not sure where I need to put that code to make it happen. Is there any predefined even for this refresh operaion in EXCEL 2002. Or something else... thank Kanan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivottable refresh in shared workbook | Excel Discussion (Misc queries) | |||
| How to refresh a Scenario PivotTable Report? | Excel Discussion (Misc queries) | |||
| Refresh a PivotTable using VBA (SQL generated Pivot) | Excel Programming | |||
| disable pivottable refresh message | Excel Programming | |||
Linear Mode
