2

Due to the application of the slicer of the sheet, the slicer itself, that was on the right side of the first data rows of the table disappeared from my view.

How can I get it back or simply remove it?

I can create a new one, but I didn't find how to edit/remove the existing one!

player0
  • 124,011
  • 12
  • 67
  • 124
Thomas B
  • 181
  • 1
  • 13

3 Answers3

3

I manage to fix this issue like this:

  1. Create a new slicer on the same table
  2. Configure the slicer on the same column
  3. In the slicer, select all items
  4. All the rows are now visible!!
  5. Remove the 2 slicers
Thomas B
  • 181
  • 1
  • 13
  • Unfortunately, in some cases you can run into the "Two slicers can either have zero or all common rows," in which case it's not possible to add a new slicer to remove the old ones. – Eric Walker Jan 13 '21 at 22:39
0
function rem_slicer(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("YOUR SHEET NAME HERE");
  var slicers = sheet.getSlicers();
  slicers[0].remove();
}

After searching for the different solutions to remove hidden slicer, I've came up to the most effective one, with running this code, which is getting any hidden slicer and removing it even if you don't remember which column it was.

mbmal
  • 13
  • 2
  • 4
    Code only answer are not the best way to help. Would be amazing if you could explain what are you doing, add a couple of comments if needed, spend some time articulating your train of thoughts. :) – Ema.jar Apr 21 '21 at 15:47
  • added explanation. this code helps much more even when you don't know exactly where was the slicer. – mbmal Apr 22 '21 at 04:22
0

Adding the error message:

"there's another slicer over these rows with a different data range"

because mbmal's solution also addresses this error.

Hopefully this will surface this solution faster for others searching for an answer.

Mint Julep
  • 11
  • 2