Share via


ExcelWebRenderer.AutomaticPeriodicDataRefresh Property

Allows unattended periodic refreshing of data.

Namespace:  Microsoft.Office.Excel.WebUI
Assembly:  Microsoft.Office.Excel.WebUI (in Microsoft.Office.Excel.WebUI.dll)

Syntax

'Declaration
<WebPartStorageAttribute(Storage.Shared)> _
<PersonalizableAttribute(PersonalizationScope.Shared)> _
<WebBrowsableAttribute(True)> _
Public Property AutomaticPeriodicDataRefresh As AutomaticPeriodicDataRefreshMode
    Get
    Set
'Usage
Dim instance As ExcelWebRenderer
Dim value As AutomaticPeriodicDataRefreshMode

value = instance.AutomaticPeriodicDataRefresh

instance.AutomaticPeriodicDataRefresh = value
[WebPartStorageAttribute(Storage.Shared)]
[PersonalizableAttribute(PersonalizationScope.Shared)]
[WebBrowsableAttribute(true)]
public AutomaticPeriodicDataRefreshMode AutomaticPeriodicDataRefresh { get; set; }

Property Value

Type: Microsoft.Office.Excel.WebUI.AutomaticPeriodicDataRefreshMode
0 if automatic periodic refresh is disabled. 1 if automatic periodic refresh is optional. 2 if automatic periodic refresh is enabled.

Remarks

When automatic refresh is set to disabled, Excel Web Access shows the periodic refresh notification without the "Always" option. (Notifications are actions that users can take to interact with Excel Web Access).

When automatic refresh is set to optional, Excel Web Access shows the periodic refresh notification with the "Always" option.

When automatic refresh is set to enabled, Excel Web Access performs an action equivalent to the periodic refresh notification "Always" option, but without showing the notification.

This setting is enabled only when the AllowPeriodicDataRefresh property is set to true. Also see the AutomaticPeriodicDataRefreshMode enumeration.

See Also

Reference

ExcelWebRenderer Class

ExcelWebRenderer Members

Microsoft.Office.Excel.WebUI Namespace