Pivot Table

[Ashok]

Hi,

Is there any way to store the pivot view at runtime and
retrieve it back. ie., the user may drag and drop any
fields in pivot and view the data as required for him.
( i need to store this view - template ).
Next time when the same user sees to it, the default view
should not be shown and the stored template is to be shown.
how to store these as templates.

Help Pls.

 

[Dave Peterson]

Maybe you could protect the workbook so the other person can't save it.

or just toss that old pivottable and rebuild it when you open the workbook.

Record a macro when you do it manually--then name that macro Auto_open.