Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Updating Pivot
Do i have to rebuild the pivot table after i add additional rows of
information to the data sheet. It seems that when i add data and i do a refresh on the pivot it does not capture the additional information. Regards |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Updating Pivot
Right click on the pivot table and select Pivot Table Wizard. Click 'Back'
and change the range it's seeing to include your new rows. acss wrote: Do i have to rebuild the pivot table after i add additional rows of information to the data sheet. It seems that when i add data and i do a refresh on the pivot it does not capture the additional information. Regards -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200903/1 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Updating Pivot
acss;285202 Wrote: Do i have to rebuild the pivot table after i add additional rows of information to the data sheet. It seems that when i add data and i do a refresh on the pivot it does not capture the additional information. Regards Hi, you can use Dynamic Ranges as des cribed here : 'Excel -- Names -- Naming Ranges' (http://www.contextures.com/xlNames01.html#Dynamic) The range will then be adapted automatically when you refresh the PT -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79689 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Updating Pivot
Thanks for the link. I am new utilizing the OFFSET function so how do you
include 7 (A through G ) named columns so it can grasp every row out to 3000? Thanks "Pecoflyer" wrote: acss;285202 Wrote: Do i have to rebuild the pivot table after i add additional rows of information to the data sheet. It seems that when i add data and i do a refresh on the pivot it does not capture the additional information. Regards Hi, you can use Dynamic Ranges as des cribed here : 'Excel -- Names -- Naming Ranges' (http://www.contextures.com/xlNames01.html#Dynamic) The range will then be adapted automatically when you refresh the PT -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79689 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Updating Pivot
Hi
Try InsertnameDefine Name myData Refers to =$A$1:INDEX($1:$65536,COUNTA($A:$A),COUNTA($1:$1)) This will give a dynamic range that will grow if you add more rows or more columns. Right click on a cell in your PTPT WizardBackSource =myData -- Regards Roger Govier "acss" wrote in message ... Thanks for the link. I am new utilizing the OFFSET function so how do you include 7 (A through G ) named columns so it can grasp every row out to 3000? Thanks "Pecoflyer" wrote: acss;285202 Wrote: Do i have to rebuild the pivot table after i add additional rows of information to the data sheet. It seems that when i add data and i do a refresh on the pivot it does not capture the additional information. Regards Hi, you can use Dynamic Ranges as des cribed here : 'Excel -- Names -- Naming Ranges' (http://www.contextures.com/xlNames01.html#Dynamic) The range will then be adapted automatically when you refresh the PT -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79689 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Table - Updating | Excel Discussion (Misc queries) | |||
updating pivot table | Excel Discussion (Misc queries) | |||
updating pivot tables | Excel Discussion (Misc queries) | |||
updating pivot tables | Excel Discussion (Misc queries) |