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.
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.
- 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.
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.
Article ID: 930253 - Last Review: Feb 15, 2012 - Revision: 1