Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 930253 - Last Review: October 15, 2007 - Revision: 1.1
The file size of an Excel workbook may unexpectedly increase exponentially
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 Users of Microsoft Office Excel 2007 are more likely to notice this issue. This is because Excel 2007 files typically are bigger than files in earlier versions of Excel. 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.
Excel 2007
- Open the shared workbook in Excel 2007.
- Click the Review tab.
- In the Changes group, click Share Workbook.
- On the Editing tab,
click the name of each user whom you want to disconnect, and then click Remove User after each name.
Microsoft Office Excel 2003 and earlier versions of Excel
- On the Tools menu, click Share Workbook, and then click the Editing tab.
- In the Who has this workbook open now box, review the list of users.
- Click the name of each user whom you want to disconnect, and then click Remove User.
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:
- Save frequently. The longer the interval between save operations, the more memory that is used by stored change records that have not been saved to the file.
- Make sure that each user closes the shared workbook daily. This procedure helps prevent ghost user names. Additionally, this procedure enables change records that are in memory to be purged.
- Periodically, look for and remove any ghost user names that are left in the workbook. Then, save and then close the workbook.
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Office Excel 2003
- Microsoft Excel 2002 Standard Edition
- Microsoft Excel 2000 Standard Edition
| kbinfo kbtshoot kbprb kbexpertisebeginner KB930253 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
KAilash
- kailash.bachhav NOSPAM-AT-NOSPAM renfroindia.com
|
Report As Irrelevant
|
| Written:
2/25/2009 2:09 AM |
|
|
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please