| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I update the data in the pulldowns at the top of the pivot
I have a simple pivot table that shows hours per month by project for each
employee. I have deleted several of the employees from the source data table, but the names continue to show up in the pulldown list at the top of the pivot table. I have refreshed the numerous times but the only way I can rid myself of the bad data is delete the pivot table and build it again. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I update the data in the pulldowns at the top of the pivot
There are instructions here for clearing old items from a pivot table:
http://www.contextures.com/xlPivot04.html DennisP wrote: I have a simple pivot table that shows hours per month by project for each employee. I have deleted several of the employees from the source data table, but the names continue to show up in the pulldown list at the top of the pivot table. I have refreshed the numerous times but the only way I can rid myself of the bad data is delete the pivot table and build it again. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update a Pivot Table with new data added to the base data | Excel Discussion (Misc queries) | |||
| Pivot Table Data did not update | Excel Worksheet Functions | |||
| How do I clear the Field pulldowns after the data is cleared? | Excel Discussion (Misc queries) | |||
| How do you update a pivot chart when the data is changed? | Excel Discussion (Misc queries) | |||
| Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
Linear Mode
