Maybe you added new data to the source table, and those rows aren't
included in the pivot table's source. To check:

Right-click on a cell in the pivot table
Click on PivotTable Wizard
Click Back, and make sure all the rows are included in the source range
Click Finish

If data will be added to the source table, you can create a dynamic
range, and base the pivot table on that, as described he

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


Gator wrote:
It displays all the data for example on month of data and will not pick up
all the data from another month?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com