To do that, you can use the PivotTableUpdate event, and a macro that moves the Slicer to the right side of the pivot table.Įach Slicer has a caption, and you can refer the the Slicer by that caption in the code. One way to fix the problem of sliding Slicers is to automatically move the Slicers, any time the pivot table is updated. As the pivot output data shrinks or expands the slicers move around and sometimes obscure each other. This happens if the slicers are viewed on top of the pivot table data. Does anyone know how to stop slicers moving around when you make selections.In the comments of the previous article, James asked how to keep those Slicers from overlapping the pivot tables. This week, we’ll use a macro to move a pivot table slicer. Recently, we saw how you can use Excel Slicers, to filter fields in one or more pivot tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |