Disable Pivot Table Ribbons

Pivot-table-based reports are useful but prone to error if target 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 generally not recommended for all users. However, these users should also be able to refresh the report and use existing filters or slicers. Aspose.Cells for Node.js via C++ provides this ability to developers for restricting users from changing these reports while creating them. For this purpose, Excel offers a feature to disable the pivot table ribbon, and the same capability is provided by Aspose.Cells for Node.js via C++. In other words, developers can disable the ribbon that contains controls for modifying these reports.

How to Disable Pivot Table Ribbon Using Aspose.Cells for Node.js via C++

The following code demonstrates this feature by accessing a pivot table from a sheet and then setting setEnableWizard to false. The sample pivot table file can be downloaded from this link.