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.
A second option that is available is the Update Changes option. This function simply allows you to define how often the spreadsheet changes are updated. The most common element users use is the Update Every 15 minutes. What this does is to force a save and filter through the data to all the users. One point to consider is that if you workbook is relatively large and you are working on a slow computer you may want to increase that time to 30 minutes. The last area of concern is the Save Changes function. This defines whose changes will override who‘s. There are two options available which say, Ask me Which Changes Win and The Changes Being Saved Win. Which option you choose really depends on the type of workbook you have created.