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.
I understand how you may feel reluctant to allow an external advisor to delve into the detail of your business. I have had other clients who felt the same way. But all of my other clients found the investment they made was repaid many times over both in their business and their own work life balance. To help you we have produced a free spreadsheet which will allow you to reflect on what you would like to achieve with your business and where you are at present. If you use the spreadsheet it will help you to identify if it would be beneficial to get an external advisor or if you are proceeding in the direction you want. Once you have completed the spreadsheet we will review the results with you if you want at no cost to you.