ExcelWebRenderer.AllowPivotSpecificOperations Property
Allows users to drill, find members, and take actions on PivotTable reports and CUBE function.
Namespace: Microsoft.Office.Excel.WebUI
Assembly: Microsoft.Office.Excel.WebUI (in Microsoft.Office.Excel.WebUI.dll)
Syntax
'Declaration
<PersonalizableAttribute(PersonalizationScope.Shared)> _
<WebBrowsableAttribute(True)> _
<WebPartStorageAttribute(Storage.Shared)> _
Public Property AllowPivotSpecificOperations As Boolean
Get
Set
'Usage
Dim instance As ExcelWebRenderer
Dim value As Boolean
value = instance.AllowPivotSpecificOperations
instance.AllowPivotSpecificOperations = value
[PersonalizableAttribute(PersonalizationScope.Shared)]
[WebBrowsableAttribute(true)]
[WebPartStorageAttribute(Storage.Shared)]
public bool AllowPivotSpecificOperations { get; set; }
Property Value
Type: System.Boolean
true if PivotTable-related operations are allowed; otherwise, false. The default is true.
Remarks
The user interfaces' entry points are hidden if this property is set to false. PivotTable-related operations such as drilling, expanding, and collapsing are also disabled.