Hi All

I have a Pivot table and data gets added by different users over time.
However when I hit refresh it does not add new records. Therefore I have to
reset the pivot chart. Is there away of doing it so it updates automatically

I have tried selecting loads more cells than needed but this does not seem
to work as it adds these cells into the results.

Any help greatly appreciated

rexmann

Hi rexmann
See if the article at
http://www.contextures.com/xlPivot01.html
does what you want.

Regards,
Pedro J.

Hi All

I have a Pivot table and data gets added by different users over time.
However when I hit refresh it does not add new records. Therefore I have to
reset the pivot chart. Is there away of doing it so it updates automatically

I have tried selecting loads more cells than needed but this does not seem
to work as it adds these cells into the results.

Any help greatly appreciated

rexmann

Nice one, thank you

Rexmann

"Infinitogool" wrote:

Hi rexmann
See if the article at
http://www.contextures.com/xlPivot01.html
does what you want.

Regards,
Pedro J.

Hi All

I have a Pivot table and data gets added by different users over time.
However when I hit refresh it does not add new records. Therefore I have to
reset the pivot chart. Is there away of doing it so it updates automatically

I have tried selecting loads more cells than needed but this does not seem
to work as it adds these cells into the results.

Any help greatly appreciated

rexmann