Also, just imagine the amount of paper you would be using all year round just to store all of those data and numbers. You can do Mother Nature a good turn by switching to using electronic spreadsheets instead of manual options. And if it is not the ease of use or the speed of the calculations that you are after, at least you would see the benefit of the automatic formatting features that come with any spreadsheet software. Now you can easily have very presentable spreadsheets done for you as you type your data inside the cells. You do not have to worry too much about the look of your spreadsheets, especially if you are presenting these to your clients. Businesses generally make extensive use of spreadsheets both in accounting and all other business fields. Being a numerically based system of analyzing information spreadsheets are used throughout every accounting function as the technique presents an ideal basis to maintain accuracy and automate the collection of financial information.
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.