Workbook.AutoUpdateFrequency Property

Excel Developer Reference

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

Note
Workbook sharing must be enabled or you may see the following error. Method 'AutoUpdateFrequency' of object '_Workbook' failed

See Also

• Workbook Object
• Workbook Object Members
• AutoUpdateSaveChanges Property
• MultiUserEditing Property
• PersonalViewListSettings Property
• PersonalViewPrintSettings Property