Article ID: 930253 - View products that this article applies to.
The file size of a Microsoft Excel workbook may unexpectedly increase exponentially. Additionally, if all the users of a shared workbook save and then close the workbook, the workbook may not decrease in file size as it should.
Note Excel 2007 files are based on a combination of XML and compression, the file types are usually smaller than legacy XLS file types. However, this issue may occur in any of the versions of Excel that are listed in the "Applies to" section.
This issue may occur if Excel closes unexpectedly. In this case, users may not be correctly disconnected from the shared workbook.
To resolve this issue, disconnect all users who are currently not using the workbook, save the workbook, and then close the workbook.
Important Verify with the users whom you want to disconnect that they are no longer actually working on the workbook. If you disconnect an active user, that user's unsaved work will be lost.
To disconnect users who are currently not using the workbook, follow these steps, as appropriate for the version of Excel that you are running.
Microsoft Office Excel 2003 and earlier versions of Excel
The issue that is described in this article may occur regardless of whether you use the Don't keep change history option in Excel. Excel keeps track of any changes that are required to synchronize the workbook between users. Excel stores these changes in memory until you save the workbook. When you save the workbook, Excel saves these changes to the hard disk drive.
Whenever Excel closes unexpectedly, ghost user names can remain in the shared workbook. The workbook tracks the version of a shared workbook to which a user was last synchronized. The workbook does this so that changes that are made after the synchronization are not purged.
To avoid the issue that is described in this article, use the following suggested practices:
Contact us for more help
Connect with Answer Desk for expert help.