Excel table greying out and adjust slicer size

[keinz]

Hi everyone,

Looking to get some assistance on this problem I cannot seem to solve...

I cleaned up a data dump into a Table so that I can apply a slicer to filter the data.

I am not using the Pivot table - as it cannot be adjusted to how I want the data to be viewed.



Anyways... for this table I have 2 slicers that I want to filter two types of data

1. Date
2. Department

The sheet has around 3000 rows and the slicer is roughly about 20 row tall and 3 rows wide.
Whenever I filter the data with the slicer and there are less rows than 20, it will resize the slicer.

In the event there are only 1 row of data - the slicer will then become unusable unless I manually resize it.
Whats weird is when the filters are applied, the bottom of the sheet is all greyed out - which is what I think is causing the slicer to resize?

I did format the slicer:
1. Disable resizing and moving (checked)
2. Don't move or size with cells (checked)
3. Locked (checked)


Yet it still happens...
I also tried protecting the worksheet, no change.

So my main question would be... how do I prevent the slicer from resizing?


Thank you in advance

 

[Alex Blakenburg]

Thanks for letting me know.
Just curious, did you resize the table to include blank rows or something ? If the table didn't cover all your data rows then the actual filtering shouldn't have worked either.

 

[keinz]

Thanks for letting me know.
Just curious, did you resize the table to include blank rows or something ? If the table didn't cover all your data rows then the actual filtering shouldn't have worked either.

so - previously the table was supposed to be from A:G

i changed it to A1:G9999

and that did it... weird

 

[Alex Blakenburg]

Thanks. At least it’s working for you now.