![]() The other SlicerCache object will be removed from the collection. ![]() ![]() MsgBox oSlicercache.Name & “,” & Īs soon as you check more than one pivot table on the PivotTable Connections dialog of a Slicer, the slicers in question will share a single SlicerCache object. The code below enumerates all slicer caches in your workbook:įor Each oSlicercache In ThisWorkbook.SlicerCaches As soon as you add a slicer to each pivot table (even if the slicer ties to the same field of the Pivot table) you get three SlicerCache objects: Each sheet has a pivot table and all Pivot tables are based on one PivotCache. So suppose we have three sheets, Sheet1, Sheet2 and Sheet3. Juggling the SlicerCaches collectionįor each slicer you add to your workbook, Excel adds a SlicerCache object too, which controls which pivot table(s) your slicer controls. For more information about slicers, read PivotTable Slicers on Jan Karel’s website. Today’s author is Jan Karel Pieterse, an Excel MVP, who explains how to work with the SlicerCache object, and how customize buttons or change slicer properties by using VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |