This procedure disconnects a user whose name currently appears in the Share Workbook dialog box. It does not prevent that user from editing the shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) again.
- 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.
Check with users you're removing to make sure they are no longer actually working on the workbook. If you remove an active user, the user's unsaved work will be lost.
- Click the name of the user you want to disconnect, and then click Remove User.
Tip
If a user no longer needs to work with a shared workbook, you can reduce the size of the workbook file by deleting the user's personal view settings. On the View menu, click Custom Views. In the Views box, click the user's view, and then click Delete.