Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to delete/clean out the row list in pivot table
i need help in cleaning out my pivot table. What i do is copy a previos
pivot table by filesave as. However after pasting my data and refreshing the pivot table, the row entries existing from the previos file is still included in the new pivot table. Say for example i have file1.xls, click-dropping the list on the row section of the pivot table displays, sup1, sup2 & sup3. Now i filesaveas file1.xls to file2.xls. Since the format of the pivot is basically the same, i just delete the source and insert a brand new set of source data. After refreshing this new pivot table and click-dropping the row list; I ended up with a selection of sup1, sup2, sup3, sup4, sup5 & sup6. When all along my new source just contains the data for sup4-6 and none for sup1-3. What i need are the steps necessary to remove the unnecessary row list on the new file without having to recreate the whole entire pivotTable all over again. |
#2
|
|||
|
|||
There are instructions here for clearing old items from a PivotTable
dropdown list: http://www.contextures.com/xlPivot04.html john² wrote: i need help in cleaning out my pivot table. What i do is copy a previos pivot table by filesave as. However after pasting my data and refreshing the pivot table, the row entries existing from the previos file is still included in the new pivot table. Say for example i have file1.xls, click-dropping the list on the row section of the pivot table displays, sup1, sup2 & sup3. Now i filesaveas file1.xls to file2.xls. Since the format of the pivot is basically the same, i just delete the source and insert a brand new set of source data. After refreshing this new pivot table and click-dropping the row list; I ended up with a selection of sup1, sup2, sup3, sup4, sup5 & sup6. When all along my new source just contains the data for sup4-6 and none for sup1-3. What i need are the steps necessary to remove the unnecessary row list on the new file without having to recreate the whole entire pivotTable all over again. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot dropdown list | Excel Worksheet Functions | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
The pivot tables 101 article says to use the "Create List" comman. | New Users to Excel | |||
Pivot Tables, can I use an external list to select data items? | Excel Worksheet Functions | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |