Multiple users working on the same excel sheet

1. Go to Tools>Share Workbook>Editing tab
2. Click Allow changes by more than one user at the same time checkbox if needed and click OK
3. Save the workbook if prompted
4. Use File>Save As to save the workbook to be shared to a network location to which both users have access 
   

Reference: Muthukumar (http://nadarmuthukumar.blogspot.in) Hope you liked this and let me know your thoughts on post through your comments :)

Posted in: Excel,Microsoft Office