PivotTable/PivotGraph - When refreshing data

[Helen]

Good day,

Excel 2003. I have created a pivot table and am using data from another
tab. When I enter new data in the data tab, let's call the field "Director",
and go back to the pivot table tab, I refresh the data, the previous data
selected still shows, along with the new data.

I would like to show only the newest data in the "Director" field, in other
words, if I added Joe Brown, and my pivot table shows Ben White, when I
refresh the table, I would like to see only Joe Brown.

Is this do-able?

Thank you for your help!

Helen

 

[smartin]

Good day,

Excel 2003. I have created a pivot table and am using data from another
tab. When I enter new data in the data tab, let's call the field "Director",
and go back to the pivot table tab, I refresh the data, the previous data
selected still shows, along with the new data.

I would like to show only the newest data in the "Director" field, in other
words, if I added Joe Brown, and my pivot table shows Ben White, when I
refresh the table, I would like to see only Joe Brown.

Is this do-able?

Thank you for your help!

Hi Helen,

If I read you right, you want to keep the old data in the source area
but only display the new records in the pivot table. To do this you need
some way to tell the pivot table which rows are new.

One way to do this would be to add a new column to the source area, call
it "New", and manually enter "Y" or "N" (or whatever makes sense to you)
on each row in that column. Then include the "New" field to your pivot
table definition and filter on the "Y" values. Unfortunately you would
have to maintain "New" manually.

 

[Helen]

Hi,

Thank you for your suggestion. I'll try it.

Helen