AutoUpdateFrequency Property

Microsoft Excel Visual Basic

Returns or sets the number of minutes between automatic updates to the shared workbook. Read/write Long.

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