Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 105
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 915
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 105
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with refreshing data Cam Excel Discussion (Misc queries) 0 April 15th 08 07:12 PM
Creating a PivotTable w/o selecting data in an existing PivotTable Damian Excel Discussion (Misc queries) 6 November 2nd 07 05:44 PM
Refreshing Data from a web query smith_gw Excel Discussion (Misc queries) 0 April 25th 07 10:44 PM
Keep column width when refreshing data Adrienne Excel Discussion (Misc queries) 0 December 11th 05 12:57 AM
Refreshing Data In Excel / VBA [email protected] Excel Discussion (Misc queries) 0 October 13th 05 10:53 AM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"