Most people are aware of the benefits of a personal health check and will not think it unusual to have one carried out periodically. It does therefore appear strange that the same people do not carry out a health check on their business. In the same way as an individual will benefit from a personal check so a business will also benefit from an early diagnosis of potential problems. In general the later a problem is identified the more drastic, painful and expensive is the solution to the problem.
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.