Pivot table page field doesn't update

[Gene]

Hello,
I'm using Excel 2000, SR-1. I have a pivot table that has
been created from a range of data on another worksheet.
When I add rows to my data & update my PT, the page field
doesn't pick up the updated data. Some of the last rows
of the "old" data don't display either. So if I have a
list of A-Z, I can only see the selections thru, say, X.
If I go into the wizard I can see that the full range of
data is selected. To get my page fields to update I've
been going into the PT wizard, deleting the page field,
then reopening the wizard & adding it again. Can anyone
point me to an easier method?
Thanks for reading,
Gene

 

[Frank Kabel]

Hi
see:
http://www.contextures.com/xlPivot01.html

 

[Guest]

-----Original Message-----
Hi
see:
http://www.contextures.com/xlPivot01.html

Thank you Frank, I'll try using a named range.

 

[CR Singh]

Did you try "Data","Refresh Data" while in the Pivot Table.