Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable/PivotGraph - When refreshing data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable/PivotGraph - When refreshing data
Helen wrote:
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable/PivotGraph - When refreshing data
Hi,
Thank you for your suggestion. I'll try it. Helen "smartin" wrote: Helen wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with refreshing data | Excel Discussion (Misc queries) | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Refreshing Data from a web query | Excel Discussion (Misc queries) | |||
Keep column width when refreshing data | Excel Discussion (Misc queries) | |||
Refreshing Data In Excel / VBA | Excel Discussion (Misc queries) |