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.