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!!!!

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!!!!

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!!!!