If you’re not already on the Editing tab after clicking Share Workbook, click it now.
Click Automatically every under “Update Changes. ” Select a number of minutes from the drop-down menu. The default is 15.
For example, if you use OneDrive and so does the person you’re sharing with, select OneDrive. If you’re on a local network, select a network folder to which you and other sharers have access.