Hey Gurus,
I'm using excel 2016 and have a bunch of grouped rows within a table. When I apply filter to the table the grouped rows show, this is something I don't want to happen, Is there any way around this.
I'm aware that if i protect the sheet and allow the user to do nothing the grouped rows will remain in place but that stops me from using the Auto filter.
Can this be fixed or is it a function that excel is yet to correct?
Thanks
I'm using excel 2016 and have a bunch of grouped rows within a table. When I apply filter to the table the grouped rows show, this is something I don't want to happen, Is there any way around this.
I'm aware that if i protect the sheet and allow the user to do nothing the grouped rows will remain in place but that stops me from using the Auto filter.
Can this be fixed or is it a function that excel is yet to correct?
Thanks