Rediger

Del via

Workbook.AutoUpdateFrequency property (Excel)

  • Artikkel

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.

ActiveWorkbook.AutoUpdateFrequency = 5

Note

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.