Microsoft KB Archive/110602

= XL: PivotTable Refresh Overwrites Formatting =

Article ID: 110602

Article Last Modified on 8/16/2005

-

APPLIES TO


 * 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:
 * 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

