If a user tries to open a Workbook that is already open, then they normally get a message saying that the File is locked by a certain user and would you like to open the file in Read only mode. However, you can open a workbook in shared mode by following these steps. First open the file that you want to share, then once the workbook is open, go to the Tools menu and choose Share Workbook from the drop down menu. The Share Workbook dialog box will now appear. To enable sharing, you simply click once on the Allow Sharing check box, so that it has a tick. Once you do this other people will now be able to use your Excel workbook whilst you are working on it.
The common feature among the spreadsheets templates is that they save time and effort and also they make the work and other calculations easier. Planning out things and fast access to data and other information are made very easy when using spreadsheet templates. But most of these templates are unique according to the purpose. The templates can be saved and used as many times as required. The electronic spreadsheets have become an office standard ever since the first such computer programs became commercially available more than 20 years ago. And with its popularity there has become a need for spreadsheet training to keep employees up to date with their knowledge and skills or using it.