Workbook.AutoUpdateFrequency Property (Excel)
Returns or sets the number of minutes between automatic updates to the shared workbook. Read/write Long.
Syntax
expression .AutoUpdateFrequency
expression A variable that represents a Workbook object.
Remarks
The AutoUpdateFrequency property must be set to a value from 5 to 1440 for this property to take effect.
Example
This example causes the shared workbook to be automatically updated every five minutes.
ActiveWorkbook.AutoUpdateFrequency = 5
Note
Workbook sharing must be enabled or you may see the following error.
Method 'AutoUpdateFrequency' of object '_Workbook' failed