To create a shared excel sheet for multiple user access at real time

How to share an excel that helps multiple user to edit same time

I need an excel sheet , where multiple users ( class 4 employees ) can post mark list of students to an excel in my office, where higher officials need to check the result entered is correct or not whereas other staffs need to download the result before publishing. All the works has to done simultaneously. here is a solution for such issues. Over usage of styles will hang the file. If two users edit the same cell, the excel asks who's data to be saved while saving the document. If two users try to save the shared excel at same time, the file will be locked, the only thing you can do at this situation is to wait until the other person saves Or wait for some times the issue will be solved.

Share workbook Option is available in Review Tab.

Click on Share

Sharing in Excel

Check the option Allow changes by more than one user at the same time.

Once you shared the excel sheet and multiple user starts working on it, Here you can see the users who are working on the excel workspace.

Allow sharing mode in excel

Click ok to share the excel

Share Excel Workspace

Track changes

To track changes made by all users use the following steps, go to track chages option in review tab, check the option when, who, where, List changes on a new sheet

Track chages in an excel

Similar posts

1. Taking reports using pivot table in ms office excel
2. How to share an microsoft office excel to work multiple user simultaneously
3. consolidate many table to one using consolidate option in ms office excel
4. Working with pivot table in microsoft office excel 2010
5. working with share point in microsoft office
6. create a internal chat application in organization

Posted by +belazy


http://javabelazy.blogspot.in/