Static view of Pivot table

Hi,
I have one pivot each in multiple worksheets in a workbook. I was wondering if there is anyway to auotmtically save a static view of the pivots that I built.

Thanks in advance,

-pload