Thursday, 7 August 2014

MS Excel - How to Remove a user from a shared workbook in Excel?

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 again.
  1. On the Tools menu, click Share Workbook, and then click the Editing tab.
  2. 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.
  3. 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.

No comments:

Post a Comment