The file that contains a PivotTable grows each time that it is saved

Article translations Article translations
Article ID: 316446 - View products that this article applies to.
This article was previously published under Q316446
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SYMPTOMS

When you save, close, and reopen an Excel file that contains a PivotTable, the file may increase in size even if there are no changes to the data in the file. This problem occurs whether or not you save the pivot data with the file, and whether or not the data is external to the Excel file.

CAUSE

Excel re-creates the drawing objects for the page field drop-down lists each time it loads the file; however, Excel does not discard the old unused page fields when it saves the file.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft Office XP. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
307841 How to obtain the latest Office XP Service Pack
The English version of this fix should have the following file attributes or later:
   Date         Time      Version      Size       File name     
   --------------------------------------------------------
   O8-FEB-2002  17:43:40  10.0.3805.0  9,169,224  Excel.exe
				

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was first corrected in Microsoft Office XP Service Pack 2 (SP-2).

Properties

Article ID: 316446 - Last Review: October 24, 2013 - Revision: 3.4
APPLIES TO
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhotfixserver kbqfe kbbug kbfix KB316446

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com