When presenting your business plan to an angel investor you must understand that they will be very interested in your spreadsheets and proformas, but you must also realize that it is typically an entrepreneurial optimistic approach, which causes problems with proformas. Therefore, you should have dueling spreadsheets; that is to say the spreadsheets, which take your best guess and double the time, double the expenses to compete with your optimistic approach. You should be able to present both of these to your Angel Investor; who chances are is a retired business person with a little bit of financial savvy.
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.