Forum Discussion
issue stop resizing cell and slicer
I did a dashboard but each time that a click a button in the slicer the row resizing the filters too. I did the following steps:
Format cells and lock all cells but still keep moving.
Format slicer Disable resizing and moving
But still row cells and slicer resizing
8 Replies
greta980 i am facing same issue, i have couple of slicers on left side of the sheet, and the file is in Teams with multiple people accepting it. As the users filter data, the slicer move from top rows of the sheet to somewhere in the middle of full data set (to 4000th rows in 7000+ rows dataset). I have already done all the settings in slicer properties to "Don't move or resize with cells" and also disabled resizing of the slicer. But still it doesn't work. Everyday i have to bring back the slicers to their original position multiple times.
Did you find any solution?
greta980 In the "Format Slicer" pane, you can also indicate "Don't move or size with cells" under Properties. That should fix it.
thanks for reply
I already did all the changes below but the issue still is there. No sure why is keep moving. I will appreciate any help
greta980 Can only replicate the issue by NOT selecting "Don't move or size with cells". By the way, the "Disable resizing and moving" check-box has nothing to with the problem. It merely enables or disables the resize-markers around the slicer and it prevents you from moving it on your worksheet by "click-and-drag".
Try the attached file. For me, the slicer does NOT resize when selecting a button.
