Article ID: 886176 - View products that this article applies to.
When you format a pivot table in Microsoft Office Excel 2003, Microsoft Office Excel 2002 or Microsoft Office Excel 2000, your changes may be lost when you close and then you reopen the file.
You may also notice that this issue occurs when you update data from an external source.
This problem occurs when you format one or more of the following table components:
To work around this issue, use the appropriate method:
Method 1: Header cell changes are lostTo resolve this issue, follow these steps:
Method 2: Column width changes are lostTo resolve this issue, follow these steps:
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.