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
auto update frequency Auto Update Frequency Property AutoUpdate AutoUpdateFrequency AutoUpdateFrequency Property Find out how often shared workbooks are updated? Return update frequency? Set the time period between automatic updates to shared workbook?

See also: