Forum Discussion
Slicers
mathetes Two screen shots attached. One is what is happening. Second is what I would like to happen.
And an hour before you posted this you said you were going to try out the FILTER function. What happened with it? It is new, to be sure, and only on the most recent releases of Excel, so you may not have been able to get it to work if you're using an older Excel. But the feedback would be helpful.
I still think it might do what you're wanting to do, and be less mysterious, since you'd be in control.
mathetes I am experimenting with the filter function right now.
TheAntony Yes. That is the way I had it set up. I finally found the problem. My table was set up incorrectly. There was one column that was a table of its own...separate from the rest of the table. Once I reset up the table, then the slicers did not resize.
