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.