updating pivot table

[lynne]

I have a spreadsheet that each month has additional rows
added with monthly information in the datasheet and for
some reason the pivot tables do not pick up the new months
information, how do I set this so that pivot table will
pick up septembers information from the datasheet and will
continue to update monthly.

Any assistance will be appreciated.

 

[Debra Dalgleish]

You can use a dynamic range as a source for the pivot table. There are
instructions here:

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