Do you mean when the source data has been changed? If so you can use a
dynamic table and refer to it then just refresh the pivot table

there are instructions for here

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


Regards,

Peo Sjoblom

"StrawberryGirl" wrote:

I am currently using PivotTables and am wondering if there is a way for the
table to automatically appear with all of the cells 'filled-in' down a column
without having to do it manually after it appears?