By Allen Wyatt for Excel.Tips.Net
PivotTables provide a great way to analyze large amounts of data and pull out the summarizations that you need. Once you have the PivotTable displaying the values you need, you can then format the table to make the data presentable—for a while. You see, when you update the data on which the PivotTable is based, and then refresh the PivotTable, all your formatting work may go away.
The way around this is to follow these steps:
1. Make sure your PivotTable displays the values you want.
2. Format the PivotTable in whatever way desired.
This post is excerpted with permission from Excel.Tips.Net
Subscribe to the Free ExcelTips Newsletter with the links below