When was the last time you needed to quickly collect some information from you colleagues and you couldn’t find an easy way to do this? When was the last time you opened an Excel Spreadsheet and it said “This workbook is locked for editing by user blah. What would you like to do?”
Problem is many people doesn’t know about a neat feature of Microsoft Excel which allows collaboration and sharing of Excel Spreadsheets. This essentially means, more than one user can edit a spreadsheet at the same time. Interested in how to do this?
In Microsoft Excel 2003, you need to follow “Tools > Share Workbook” menu:
In Microsoft Excel 2007, this option is located in “Review” ribbon:
Firing above option shows a dialog presenting a check-box which says something like “Allow changes by more than one user at the same time..blah blah”. Select this option and save the work book in a network location where all the persons who need to edit this workbook has write access and you are done!