Forum Discussion

greta980's avatar
greta980
Copper Contributor
May 27, 2020

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 sli...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 27, 2020

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

  • greta980's avatar
    greta980
    Copper Contributor
    Jun 22, 2020

    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

     

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jun 22, 2020

      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.

       

      • thomastoh's avatar
        thomastoh
        Copper Contributor
        Sep 14, 2021

        Riny_van_Eekelen Hi, I face a similar issue with my file.

        For my case, my file is stored in OneDrive/SharePoint and shared with other users for co-authoring. The issue happened when someone trying to apply the slicer in Exel Online, then it will cause the slicer in Excel App to auto resize. 

Resources