May 27 2020 01:46 AM
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
May 27 2020 03:23 AM
@greta980 In the "Format Slicer" pane, you can also indicate "Don't move or size with cells" under Properties. That should fix it.
Jun 21 2020 09:47 PM
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
Jun 21 2020 10:27 PM
@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.