AutoUpdateFrequency Property
Returns or sets the number of minutes between automatic updates to the shared workbook. If this property is set to zero (0), updates occur only when the workbook is saved. Read/write Long.
Example
This example causes the shared workbook to be automatically updated every three minutes.
ActiveWorkbook.AutoUpdateFrequency = 3