AutoUpdateFrequency Property

Applies To

Workbook object.

Description

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.

See Also

AutoUpdateSaveChanges property, MultiUserEditing property, PersonalViewListSettings property, PersonalViewPrintSettings property, SaveAs method.

Example

This example causes the shared workbook to be automatically updated every three minutes.

ActiveWorkbook.AutoUpdateFrequency = 3