So this is the Customer field, make sure the Customer is not in the list. Here's, what I think, the steps should be to delete a slicer.įirst thing, make sure that your Pivot Table does not have, whatever field in the slicer is. Let me bring the slicer back, we'll choose a few Customers. So we're back to the original question: how do you get rid of a slicer?
So I have successfully decoupled it from the Pivot Table, let's say, but it doesn't mean, that I've gotten all the Customers back. Now, it truly is no longer connected to the Pivot Table, because if I would try and clear the slicer or choose other Customers from the slicer, it's not changing the Pivot Table. It's still cached, even though this slicer is no longer connected to the Pivot Table. I could find this button, says “Report Connections” and in the Report Connections I could say, hey, I want this Pivot Table to no longer be associated with that slicer, click OK, and we go back to 6.7 million.īut let me add Customer in and it still remembers those five Customers. I thought, okay, well, what if we come out here to slicer tools options and look for a button that says “Delete”. Let's put the slicer back in and we'll choose a few Customers. It doesn't seem logical to me, it doesn't seem logical to me. So I had 6.7 million, I added Customer in, and I'm down to 739 thousand. We've cached the former state of that and as soon as I take, for example Product out and put Customer back in… huh, the three Customers come back, isn't that bizarre? The Customer field, it has that grey funnel that says: hey, there is still something that we're caching. They've actually remembered what is in the slicer and we have a little clue over here, at the Pivot Table Fields list. So let me take Customer out and replace it with Product.Īll right, so we have 6.7 million dollars, I choose a few Customers, and we're down to 739 thousand dollars.Īnd then I click here to delete the slicer and hey, wait, the rules changed. So to them, you know, the slicer… when we delete the slicer, we're just saying: hey, we don't want to use that part of the user interface anymore.īut we're going to keep the Customers that you selected, when you were using it.Īll right, which was kind of interesting to me.Īnd the behavior actually changes a lot, whether Customer is in the table or not. You know, choose (Select All) a couple of times, and then choose the Customers that you want. That filter persists even after you delete the slicer.Īnd it turns out, I talked to some folks at Microsoft, and in their view, the slicer is nothing special, it's just a great big shortcut way to avoid having to open this drop-down. So here's a slicer, where we choose three Customers and see, it shows up in the Pivot Table, right.Īnd you say, all right, well, if I'm no longer going to use this slicer, you would think you would just click here on the white space and press Delete, and that all of the Customers would come back. So actually, I do a little bit of research on this. I read that question, I said well, that should be easy, it should be easy to delete a slicer.īut it turns out that it's not easy to delete slicer. It was a great seminar, we had 700 people watching me do Pivot Tables and right at the end, a question came and it said: how do you delete a slicer? The Dueling podcast will come back, but for right now, you're stuck with just me.Īll right, yesterday I was doing a seminar for the customers of the company excel4apps. I want to send “Get Well” wishes to Mike Girvin, who is on injured reserve this week. Hey, if you're a regular viewer of the podcast, it's Friday and you're saying: wait a second, Friday is for Dueling Excel!
The MrExcel podcast is sponsored by Easy-XL.
0 kommentar(er)
