This documentation is archived and is not being maintained.

Workbook.AutoUpdateFrequency Property

Office 2007
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.

Visual Basic for Applications
ActiveWorkbook.AutoUpdateFrequency = 5
Bb220869.vs_note(en-us,office.12).gif  Note
Workbook sharing must be enabled or you may see the following error.
Method 'AutoUpdateFrequency' of object '_Workbook' failed



Show: