AutoUpdateFrequency Property

Microsoft Excel Visual Basic

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