XL: PivotTable Refresh Overwrites Formatting (110602)


The information in this article applies to:

  • Microsoft Excel for Windows 5.0
  • Microsoft Excel for Windows 5.0c
  • Microsoft Excel for Windows NT 5.0
  • Microsoft Excel for Windows 95
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:
  1. On the Format menu, click AutoFormat.
  2. In the Table Format box, click an autoformat.
  3. 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

Modification Type:MinorLast Reviewed:8/16/2005
Keywords:kbprb KB110602
©2004 Microsoft Corporation. All rights reserved.