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.
