Sets or returns whether the worksheet will allow users to use PivotTable reports when the worksheet is protected.
public boolean AllowUsePivotTableReports{ get; set; }
Public Property AllowUsePivotTableReports() As Boolean
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws = wb.Worksheets[0]; ws.SheetProtection.AllowUsePivotTableReports = true; ws.Protect("password");
Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx") Dim ws As Worksheet = wb.Worksheets(0) ws.SheetProtection.AllowUsePivotTableReports = true ws.Protect("password");