PivotTable/PivotGraph - When refreshing data

H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The PivotTable field name is not valid (error) 1
Refresh order when refreshing all in a workbook 1
Pivot ungrouping on refresh? 3
Pivot table refreshing 5
Refreshing a pivot table 1
Refreshing Pivot Table on a protected spreadsheet tab 1
PivotTable missing data 2
Pivot Refresh Error when calling Excel Macro from VB.NET program 0

Top