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.
Most business owners know how they want to run their business. To a large extent this is based on the business owner‘s personal values, ethics and interests. Sometimes the day to day problems pile up at such a rate the owner loses sight of what they wanted to achieve as they get buried under layers of demands on their time. Most people would not consider carrying out a health check on themselves. Instead they consult an external expert who will take an objective look at them and provide impartial advice. In business a similar route should be followed as anyone involved in the day to day running of a business may not notice a significant problem due to familiarity. The old adage about the value of a fresh pair of eyes is true in business as it is elsewhere.