Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table question
Do you know how I can ensure that, when
new records are added to my source document, that the new records are captured in the pivot table when it's refreshed? Currently, I can update the pivot table successfully if I delete records from the source document, but not if I add records |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table question
One method - establish the range of data to be used in the Pivot Table as a
defined name - InsertNameDefine (Refers to) would be the absolute value of the data range... Name the data range something that is relative like RawData Open the Pivot Table Wizard and on Step 2 use the defined name from above to identify the Range, just type the defined name exactly as you established it in the step above... RawData... I generally establish a little "Update Data" button on an assumptions page which runs a simple macro to select the worksheet with the data, place the cursor in the top cell and then select the current region to re-establish the data range anytime the data changes (Adds or Deletes) Right click on the Pivot Table and select Table Options select Refresh on Open -- HTH Joe Mac " wrote: Do you know how I can ensure that, when new records are added to my source document, that the new records are captured in the pivot table when it's refreshed? Currently, I can update the pivot table successfully if I delete records from the source document, but not if I add records |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table question
Thanks so much--this works very well. I appreciate your help!
Joe Mac wrote: One method - establish the range of data to be used in the Pivot Table as a defined name - InsertNameDefine (Refers to) would be the absolute value of the data range... Name the data range something that is relative like RawData Open the Pivot Table Wizard and on Step 2 use the defined name from above to identify the Range, just type the defined name exactly as you established it in the step above... RawData... I generally establish a little "Update Data" button on an assumptions page which runs a simple macro to select the worksheet with the data, place the cursor in the top cell and then select the current region to re-establish the data range anytime the data changes (Adds or Deletes) Right click on the Pivot Table and select Table Options select Refresh on Open -- HTH Joe Mac " wrote: Do you know how I can ensure that, when new records are added to my source document, that the new records are captured in the pivot table when it's refreshed? Currently, I can update the pivot table successfully if I delete records from the source document, but not if I add records |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Pivot Table question | Excel Discussion (Misc queries) | |||
Pivot Table Question | New Users to Excel | |||
Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Pivot Table Question | Excel Discussion (Misc queries) |