issue stop resizing cell and slicer

%3CLINGO-SUB%20id%3D%22lingo-sub-1419927%22%20slang%3D%22en-US%22%3Eissue%20stop%20resizing%20cell%20and%20slicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1419927%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20did%20a%20dashboard%20but%20each%20time%20that%20a%20click%20a%20button%20in%20the%20slicer%20the%20row%20resizing%20the%20filters%20too.%20I%20did%20the%20following%20steps%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EFormat%20cells%20and%20lock%20all%20cells%20but%20still%20keep%20moving.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EFormat%20slicer%20Disable%20resizing%20and%20moving%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EBut%20still%20row%20cells%20and%20slicer%20resizing%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22picture.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194714iC6910D5F562DB907%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22picture.png%22%20alt%3D%22picture.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1419927%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1420088%22%20slang%3D%22en-US%22%3ERe%3A%20issue%20stop%20resizing%20cell%20and%20slicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F680783%22%20target%3D%22_blank%22%3E%40greta980%3C%2FA%3E%26nbsp%3BIn%20the%20%22Format%20Slicer%22%20pane%2C%20you%20can%20also%20indicate%20%22Don't%20move%20or%20size%20with%20cells%22%20under%20Properties.%20That%20should%20fix%20it.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-05-27%20at%2012.21.16.png%22%20style%3D%22width%3A%20212px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194722i64633BD842D77FB0%2Fimage-dimensions%2F212x163%3Fv%3D1.0%22%20width%3D%22212%22%20height%3D%22163%22%20title%3D%22Screenshot%202020-05-27%20at%2012.21.16.png%22%20alt%3D%22Screenshot%202020-05-27%20at%2012.21.16.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1479975%22%20slang%3D%22en-US%22%3ERe%3A%20issue%20stop%20resizing%20cell%20and%20slicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479975%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20reply%26nbsp%3B%3C%2FP%3E%3CP%3EI%20already%20did%20all%20the%20changes%20below%20but%20the%20issue%20still%20is%20there.%20No%20sure%20why%20is%20keep%20moving.%20I%20will%20appreciate%20any%20help%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22greta980_0-1592801345159.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199966i3DFC69B98339F0D9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22greta980_0-1592801345159.png%22%20alt%3D%22greta980_0-1592801345159.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480026%22%20slang%3D%22en-US%22%3ERe%3A%20issue%20stop%20resizing%20cell%20and%20slicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480026%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F680783%22%20target%3D%22_blank%22%3E%40greta980%3C%2FA%3E%26nbsp%3BCan%20only%20replicate%20the%20issue%20by%20NOT%20selecting%20%22Don't%20move%20or%20size%20with%20cells%22.%20By%20the%20way%2C%20the%20%22Disable%20resizing%20and%20moving%22%20check-box%20has%20nothing%20to%20with%20the%20problem.%20It%20merely%20enables%20or%20disables%20the%20resize-markers%20around%20the%20slicer%20and%20it%20prevents%20you%20from%20moving%20it%20on%20your%20worksheet%20by%20%22click-and-drag%22.%3C%2FP%3E%3CP%3ETry%20the%20attached%20file.%20For%20me%2C%20the%20slicer%20does%20NOT%20resize%20when%20selecting%20a%20button.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

 

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

picture.png

3 Replies

@greta980 In the "Format Slicer" pane, you can also indicate "Don't move or size with cells" under Properties. That should fix it.

Screenshot 2020-05-27 at 12.21.16.png

@Riny_van_Eekelen 

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_0-1592801345159.png

 

@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.