Field list in Pivot tables

  • Thread starter Thread starter Prixt0n
  • Start date Start date
P

Prixt0n

I have a problem with the field lists. I have a field for Year. How
can I update the field list to include new year like 2009? Please
help, Thanks
 
Hi,

This sounds like you have columns in the data source for each year? If so,
select anywhere in the PivotTable and choose PivotTable, PivotTable Wizard,
click the Back button once, hold down the Shift key and press the Right arrow
key once to include the new column. Finish
 
Hi,

This sounds like you have columns in the data source for each year?  Ifso,
select anywhere in the PivotTable and choose PivotTable, PivotTable Wizard,
click the Back button once, hold down the Shift key and press the Right arrow
key once to include the new column.  Finish

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire





- Visa citerad text -
Click to expand...

No, I only have one column with Year but in the PivotTable, the field
list does not update to include the new year.
 
Hi

Have you got a fixed range for your source data, and is it not including the
latest rows entered?
Try creating a Dynamic named range

Assuming your data starts in A1
Insert>Name>Define>
Name myData
Refers to =$A$1:INDEX$1:$65536,COUNTA($A:$A),COUNTA($1:$1))

Right click on any cell in your PT>PT Wizard>Back>Source =myData>Finish
 
Hi

Have you got a fixed range for your source data, and is it not including the
latest rows entered?
Try creating a Dynamic named range

Assuming your data starts in A1
Insert>Name>Define>
Name        myData
Refers to    =$A$1:INDEX$1:$65536,COUNTA($A:$A),COUNTA($1:$1))

Right click on any cell in your PT>PT Wizard>Back>Source  =myData>Finish
--
Regards
Roger Govier







- Visa citerad text -
Click to expand...

Hi,
The field list does not update, even if I insert new columns or remove
columns. I use 2007
 
Hi
If you want to send me a copy of the file I will take a look.
To send direct
roger at technology4u dot co dot uk
Change the at and dots to make a valid email address
 
Hi
If you want to send me a copy of the file I will take a look.
To send direct
roger at technology4u dot co dot uk
Change the at and dots to make a valid email address

--
Regards
Roger Govier







- Visa citerad text -
Click to expand...

Thank you Roger, You had the solution for me.

Regards
 
For the benefit of the archives, the data range was fixed and did not
include the row for 2009.

As it was XL2007, I suggested Insert tab>Table>My table has headers.
Then cursor within Table>Table Tools>Summarize with Pivot Table.

I also gave the OP the formula for creating a Dynamic range through Formula
tab>Name Manager
I had missed out a parenthesis in my earlier posting

=$A$1:INDEX($1:$65536,COUNTA($A:$A),COUNTA($1:$1))
 
Back
Top