ExcelWebRenderer.AllowInteractivity Property

Allows users to interact with the workbook.

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

Syntax

'Declaration
<WebBrowsableAttribute(True)> _
<WebPartStorageAttribute(Storage.Shared)> _
<PersonalizableAttribute(PersonalizationScope.Shared)> _
Public Property AllowInteractivity As Boolean
    Get
    Set

'Usage
Dim instance As ExcelWebRenderer
Dim value As Boolean

value = instance.AllowInteractivity

instance.AllowInteractivity = value

[WebBrowsableAttribute(true)]
[WebPartStorageAttribute(Storage.Shared)]
[PersonalizableAttribute(PersonalizationScope.Shared)]
public bool AllowInteractivity { get; set; }

Property Value

Type: System.Boolean
true if users are allowed to interact with the workbook; otherwise, false. The default is true.

Remarks

The following options are disabled if this property is set to false:

• AllowManualDataRefresh

• AllowPeriodicDataRefresh

• AllowRecalculation

• AllowParameterModification

• AllowSorting

• AllowFiltering

• AllowPivotSpecificOperations

When this property is set to false, no interactivity is allowed in the workbook.

See Also

Reference

ExcelWebRenderer Class

ExcelWebRenderer Members

Microsoft.Office.Excel.WebUI Namespace