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