Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problems with updating category names in pivot tables
I have an issue with pivot tables, previously my pivot table contained months
where each month was written like "January, February" etc, but now I have changed the way the months are written to "01-january, 02-february". My problem is that even though the data with the old month names no longer exists in the pivot table, the pivot table still provides "January, February" etc. as filtering options in the month category. I've tried updating the pivot table but it doesnt help. The only way i've been able to get rid of this was by creating a new pivot table. Now I have an issue with changing the names of people assigned to different functions, as people join and leave the company I am annoyed that all of the old employees are still listed in my filters, how can I fix this issue without having to create a new pivot table every time? |
#2
|
|||
|
|||
Problems with updating category names in pivot tables
Hi Vladimir
Yes, its really annoying isn't it. Simple solution though which is well explained by Debra at http://www.contextures.com/xlPivot04.html Regards Roger Govier Vladimir wrote: I have an issue with pivot tables, previously my pivot table contained months where each month was written like "January, February" etc, but now I have changed the way the months are written to "01-january, 02-february". My problem is that even though the data with the old month names no longer exists in the pivot table, the pivot table still provides "January, February" etc. as filtering options in the month category. I've tried updating the pivot table but it doesnt help. The only way i've been able to get rid of this was by creating a new pivot table. Now I have an issue with changing the names of people assigned to different functions, as people join and leave the company I am annoyed that all of the old employees are still listed in my filters, how can I fix this issue without having to create a new pivot table every time? |
#3
|
|||
|
|||
Problems with updating category names in pivot tables
Great, thanks a lot! I've been annoyed by this bug for the past year and
finally I have a solution :-) "Roger Govier" wrote: Hi Vladimir Yes, its really annoying isn't it. Simple solution though which is well explained by Debra at http://www.contextures.com/xlPivot04.html Regards Roger Govier Vladimir wrote: I have an issue with pivot tables, previously my pivot table contained months where each month was written like "January, February" etc, but now I have changed the way the months are written to "01-january, 02-february". My problem is that even though the data with the old month names no longer exists in the pivot table, the pivot table still provides "January, February" etc. as filtering options in the month category. I've tried updating the pivot table but it doesnt help. The only way i've been able to get rid of this was by creating a new pivot table. Now I have an issue with changing the names of people assigned to different functions, as people join and leave the company I am annoyed that all of the old employees are still listed in my filters, how can I fix this issue without having to create a new pivot table every time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Page Field of Pivot Tables from Form Control | Excel Discussion (Misc queries) | |||
Pivot Tables - updating individual columns | Excel Worksheet Functions | |||
updating pivot tables | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |