MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table Formatting


Posted by Jan on September 28, 2001 6:13 AM

I use Excel to create a Pivot Table for our court calendar each week. I would like to know if there is a way to keep the formatting of the Pivot Table when I refresh the data.


Posted by Mark W. on September 28, 2001 6:32 AM

Yes...

...make sure that you've Enabled Selection and set
all of your PAGE fields to "(All)" before you
apply your formatting.

See the Excel Help topics for...

"Format a PivotTable"

"Formatting is lost when my PivotTable is
refreshed or I change its layout"

Posted by jen on September 28, 2001 12:40 PM

In the "Pivot Table" drop down menu, "Table Options", select/check "Preserve Formatting". This should maintain your formatting changes when you refresh data.