Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table - New Data
When I add data to my excel spreadsheet and update my pivot table with the
new cell range, the new data is automaticlly selected in the drop down feilds in the pivot table. Is their any way to have the pivot table update but leave my orginal selections in place. For example here is a very simple senario: My orginal data has 10 cost centers, I only select five of them when making my pivot table report. I update my data with an additional 7 cost centers. When I update the pivot table the orginal 5 cost centers are still selected but the new 7 cost centers are also selected. I want to find a way to update my pivot table with the new cell range but to keep my orginal report criteria (only 5 cost centers selected). Help!!!! |
#2
|
|||
|
|||
pivot table - New Data
Allen
The easiest way would be to add a field in your original data to show whether the cost centre should be reported. This could be controlled by an "if" or "vlookup" formula. This "Report" field just needs to read "Y" or "N". Then put this field into the "Page" area on the Pivot Table and then change the selection to only show those with "Y". Using the Lookup facility would be more flexible and allow amendment of the selection and this could be made to be more sofisticated by amending this field to be "Department" so that the "Page" provides more options quickly. The only other way is to de-select the unwanted cost centers in the Pivot Table drop-down, as they are created. Hope this helps Roger "Allen" wrote: When I add data to my excel spreadsheet and update my pivot table with the new cell range, the new data is automaticlly selected in the drop down feilds in the pivot table. Is their any way to have the pivot table update but leave my orginal selections in place. For example here is a very simple senario: My orginal data has 10 cost centers, I only select five of them when making my pivot table report. I update my data with an additional 7 cost centers. When I update the pivot table the orginal 5 cost centers are still selected but the new 7 cost centers are also selected. I want to find a way to update my pivot table with the new cell range but to keep my orginal report criteria (only 5 cost centers selected). Help!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table - New Data
Thanks for the help. I really appreciate your time.
"RogerN" wrote: Allen The easiest way would be to add a field in your original data to show whether the cost centre should be reported. This could be controlled by an "if" or "vlookup" formula. This "Report" field just needs to read "Y" or "N". Then put this field into the "Page" area on the Pivot Table and then change the selection to only show those with "Y". Using the Lookup facility would be more flexible and allow amendment of the selection and this could be made to be more sofisticated by amending this field to be "Department" so that the "Page" provides more options quickly. The only other way is to de-select the unwanted cost centers in the Pivot Table drop-down, as they are created. Hope this helps Roger "Allen" wrote: When I add data to my excel spreadsheet and update my pivot table with the new cell range, the new data is automaticlly selected in the drop down feilds in the pivot table. Is their any way to have the pivot table update but leave my orginal selections in place. For example here is a very simple senario: My orginal data has 10 cost centers, I only select five of them when making my pivot table report. I update my data with an additional 7 cost centers. When I update the pivot table the orginal 5 cost centers are still selected but the new 7 cost centers are also selected. I want to find a way to update my pivot table with the new cell range but to keep my orginal report criteria (only 5 cost centers selected). Help!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
pivot table | Excel Discussion (Misc queries) | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |