Knowledge Base

XL: PivotTable Refresh Overwrites Formatting

Article ID: 110602

Article Last Modified on 8/16/2005

Microsoft Excel 5.0 Standard Edition
Microsoft Excel 5.0c
Microsoft Excel 5.0 Standard Edition
Microsoft Excel 95 Standard Edition

This article was previously published under Q110602

SYMPTOMS

When you apply formatting to individual cells in a PivotTable, this individual formatting is lost when the PivotTable data is refreshed.

WORKAROUND

Change the automatic PivotTable formatting, which is applied in the last step of the PivotTable Wizard. To do this, follow these steps to autoformat the table:

On the Format menu, click AutoFormat.
In the Table Format box, click an autoformat.
Click OK.

Refreshing the data does not change the applied autoformat.

Note that if other cells not contained within the PivotTable are included in the AutoFormat process, formatting is lost from the PivotTable when the data is refreshed. To prevent this from occurring, make sure that the autoformatting applied to the PivotTable is not also applied to adjacent cells.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

118371 XL: Data Number Formatting Lost When You Create PivotTable

REFERENCES

"User's Guide," version 5.0, Chapter 25

For more information about formatting PivotTables, choose the Search button in Help and type:

Pivot Tables

For more information about AutoFormat, choose the Search button in Help and type:

AutoFormat

Additional query words: pivot table pt auto format formatting

Keywords: kbprb KB110602