Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE OBSOLETE INFORMATION FROM PIVOT TABLE
I have a pivot table for my wages file. when an employee leaves i would
like to remove them completely from the field as it can get quite full |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE OBSOLETE INFORMATION FROM PIVOT TABLE
Delete the employee from the data source and then refresh your pivot table.
To refresh the pivot table, move the cell pointer to a cell in the pivot table, right click on any tool bar and select the PIVOT TABLE tool bar, and click the button with the exclamation point on it to refresh the pivot. -- Kevin Backmann "narkiparki" wrote: I have a pivot table for my wages file. when an employee leaves i would like to remove them completely from the field as it can get quite full |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE OBSOLETE INFORMATION FROM PIVOT TABLE
Many thanks for quick reply, if it were only that easy. have tried that
before and it doesn't work. even making a new copy of the file and deleting all employee info from it, they still remain in the field! claire "Kevin B" wrote: Delete the employee from the data source and then refresh your pivot table. To refresh the pivot table, move the cell pointer to a cell in the pivot table, right click on any tool bar and select the PIVOT TABLE tool bar, and click the button with the exclamation point on it to refresh the pivot. -- Kevin Backmann "narkiparki" wrote: I have a pivot table for my wages file. when an employee leaves i would like to remove them completely from the field as it can get quite full |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE OBSOLETE INFORMATION FROM PIVOT TABLE
You need to delete the entire row from the table, not just the data
pertaining to an employee. Leaving a blank row in the table will generate a blank row in your pivot table. -- Kevin Backmann "narkiparki" wrote: Many thanks for quick reply, if it were only that easy. have tried that before and it doesn't work. even making a new copy of the file and deleting all employee info from it, they still remain in the field! claire "Kevin B" wrote: Delete the employee from the data source and then refresh your pivot table. To refresh the pivot table, move the cell pointer to a cell in the pivot table, right click on any tool bar and select the PIVOT TABLE tool bar, and click the button with the exclamation point on it to refresh the pivot. -- Kevin Backmann "narkiparki" wrote: I have a pivot table for my wages file. when an employee leaves i would like to remove them completely from the field as it can get quite full |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE OBSOLETE INFORMATION FROM PIVOT TABLE
There are instructions here for removing old items from a pivot table:
http://www.contextures.com/xlPivot04.html narkiparki wrote: I have a pivot table for my wages file. when an employee leaves i would like to remove them completely from the field as it can get quite full -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE OBSOLETE INFORMATION FROM PIVOT TABLE
MANY THANKS!!
SORTED! "Debra Dalgleish" wrote: There are instructions here for removing old items from a pivot table: http://www.contextures.com/xlPivot04.html narkiparki wrote: I have a pivot table for my wages file. when an employee leaves i would like to remove them completely from the field as it can get quite full -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot table formatting | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions |