Disable Resizing and Moving Slicer|Dashboards & Charts|Excel Forum|My Online Training Hub

Hello

It's my first post but I'm an avid watcher of the YouTube videos, and I hope someone can help me.

I set up a dashboard in December which contained a number of slicers that were utilising the 'Disable resizing and moving' functionality, and that was working well.

One of the slicers now has an extra category and I need to resize it to accommodate this, however, in the Format Slicer window I now don't have access to the 'disable resizing and moving' check box - it's disappeared.

Even creating a new, very simple pivot and inserting a slicer doesn't give me the option to 'disable resizing and moving' (see screenshot).  Where has it gone? I've looked in every available menu option and Googled, but can't find any information on this.  Even my partner, who works for another company doesn't have this feature in Excel either.

I'm using Microsoft 365 Apps for enterprise, version 2008 (Build 13127.21348).  Since I created the dashboard we have had a Windows 10 upgrade in the last few weeks so I'm wondering whether this has anything to do with it?

I now have a dashboard where I can't filter on certain categories because I can't edit it!  Help!

Thanks