preserve formatting option in pivot table option dialog box

[Guest]

Anyone know what the "Preserve formatting" checkbox does in the pivot table
dialog box? I was just asked this by a colleague and I have no clue....

 

[Debra Dalgleish]

If you don't have that option checked, some of the pivot table
formatting may be lost when you refresh the pivot table.

 

[Guest]

That would make sense, thanks.

 

[Guest]

No matter if "Preserve Formatting" is checked or not, some, not all of my
formatting of pivot tables gets lost after refresh (Excel 2002). Somebody
once also said "Enable Selection" affects the formatting....that doesn't work
either. Is there a definitive source on how to format and pivot table and
have the formatting hold?

Thanks

 

[Karen Robertson]

I get the message "The Enable Selection button on the Select submenu (Pivot
table menu) is not pressed in."

I have tried every way possible and do not see how to press in this button.
My company has a really old version of Excel 97 SR-2. It has been many years
since I worked with this version. HELP! Every time I refresh, it takes away
the formatting on my pivot.