Pivot Table Refresh Overwrites Formatting

ID: Q110602

The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you apply formatting to individual cells in a pivot table, this individual formatting will be lost when the pivot table data is refreshed.


WORKAROUND

Change the automatic pivot table formatting, which is applied in the last step of the Pivot Table Wizard. To do this, autoformat the table by following these steps:

  1. On the Format menu, click AutoFormat.


  2. In the Table Format box, click an autoformat.


  3. Click OK.


Refreshing the data will not change the applied autoformat.

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

For additional information, please see the following article in the Microsoft Knowledge Base:
Q118371 XL: Data Number Formatting Lost Creating Pivot Table


REFERENCES

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

For more information about formatting pivot tables, 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: pivottable pt auto format formatting

Keywords :
Version : WINDOWS:5.0,5.0c,7.0,97; winnt:5.0
Platform : WINDOWS winnt
Issue type : kbprb


Last Reviewed: July 8, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.