Workbook.AutoUpdateFrequency (Excel)

Returns or sets the number of minutes between automatic updates to the shared workbook.

The AutoUpdateFrequency property must be set to a value from 5 to 1440 for this property to take effect.

ActiveWorkbook.AutoUpdateFrequency = 4