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. 

      • pieterjanst's avatar
        pieterjanst
        Copper Contributor
        Feb 15, 2022
        I have the same issue in a shared file on a SharePoint site (Teams folder). When people start filtering a table next to it, or editing cells, the slicer's height suddenly explodes to a very high number.
        Please fix..

Resources