Disable Pivot Table Ribbons with Golang via C++

Pivot table‑based reports are useful but prone to errors if end users do not have detailed knowledge of Excel to configure these reports. In these circumstances, organizations will want to restrict users from being able to change a pivot table‑based report. Common pivot table features, such as adding additional filters, slicers, fields, or changing the order of items in the report, are not recommended for all users. However, these users must also be able to refresh the report and use existing filters or slicers. Aspose.Cells provides this ability to developers for restricting users from changing these reports while creating them. For this purpose, Excel provides a feature to disable the pivot table ribbon, and the same feature is provided by Aspose.Cells. Developers can disable the ribbon that contains controls to modify these reports.

Disable Pivot Table Ribbon using PivotTable.EnableWizard

The following code demonstrates this feature by accessing a pivot table from a sheet and then setting the GetEnableWizard() method to false. A sample pivot table file can be downloaded from this link.