Remove Pivot Connection

Possible Usage Scenarios

If you want to disassociate the slicer and pivot table in Excel, you need to right‑click the slicer and select the “Report Connections…” item. In the options list, you can check or uncheck the box. Similarly, if you want to disassociate the slicer and pivot table using Aspose.Cells for Python via .NET API programmatically, please use the Slicer.remove_pivot_connection(pivot) method. It will disassociate the slicer and the pivot table.

How to Disassociate Slicer and Pivot Table Using Aspose.Cells for Python Excel library

The following sample code loads the sample Excel file that contains an existing slicer. It accesses the slicers and then disassociates the slicer and the pivot table. Finally, it saves the workbook as output Excel file.

Sample Code