pivot table changes when data is refreshed.

[isskiran]

Hi,
I have a pivot table with grouping based on a field called "period
which is of date type. I have grouped it into months and quarters
However when i refresh the pivot table whenever the data (which is in
seperate sheet) is changed, the groupings are going out. I want t
preserve the groupings as they are like a template. How do i stop th
changing the format and layout of the pivot table whenever i refres
the data? any ideas? please help.
regards
Kiran:mad

 

[Tushar Mehta]

Intentionally or otherwise, XL does not retain all of the custom
formatting applied to a PivotTable. Two documented examples are:

XL2000: PivotTable Does Not Preserve Conditional Formatting
http://support.microsoft.com/default.aspx?scid=kb;en-us;215986

XL97: Formatting Not Retained in PivotTable
http://support.microsoft.com/default.aspx?scid=kb;en-us;162028

You might find more information by searching the MSKB.

--
[Posted directly to the Usenet newsgroup -- no affiliation with
Excelforum]

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions