Sharing Excel Workbook Between Multiple Users on Shared Drive

Excel provides a feature to share excel workbook or excel file between multiple users. Sharing excel file enables us to simultaneously work on a single excel file which can’t be done otherwise.

Shared workbook solves the problem of exception thrown by excel ie. File locked for editing by ‘another user’.

To share your excel file > Go to Tools > Share Workbook.

In Share Workbook, click on Editing Tab > Select Allow changes by more than on user…. checkbox.

Then click on Ok to share your excel workbook.

After sharing workbook it shows [Shared] on title bar of your excel workbook.

You can view changes done by users on excel workbook by following below steps:

Go to Tools > Highlight Changes > Check List changes on new sheet & track changes while editing and  uncheck others.

Tags: , ,

Comments & Responses

Leave a Reply

Your email address will not be published. Required fields are marked *


5 + 9 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>