Excel.Tips.Net: Maintaining Formatting when Refreshing PivotTables

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.

Steps 3-8/Article Continued Here

This post is excerpted with permission from Excel.Tips.Net

Subscribe to the Free ExcelTips Newsletter with the links below

(for those using Excel 97 through 2003)

(for those using Excel 2007 through 2010)

37 total views, 1 views today

(Visited 2 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.