Advanced Filter with slicer return error

I have an issue in the attached file when trying to export filtered data to another sheet with advanced filter recorded with vba, when table's slicers are in another sheet "Slicers Sheet", the macro return an error "Run-time error '1004': AdvancedFilter method of Range class failed".

your support will be highly appreciated, noting that my original file include more than 2 slicers if this info matters.

Try...

Please Login or Register  to view this content.

Thanks for your reply, but still the same error shows after applying the code (sample attached with the new code)

Kinda weird, I dl'd it and it works for me. Try it this way...

Please Login or Register  to view this content.

Really weird if it works for you with my attached sample file and not for me!!!
the new code also show the same error for me.
I attached a screenshot for the error message when running the macro, and another screenshot after selecting Debug.
Thank you for your effort with the issue.

Can you use advanced filter on a table if it has slicers?
As soon as I put slicers on a table, the Filter & advanced filter options are greyed out.
If you delete the slicers the code works.

I run advanced filter option outside the table, by selecting any blank cell, but I have the below 2 scenarios:

1- If I run advanced filter in the same sheet where the table exists, it accept the query and run but slicers shows Out-of-date and must be updated manually to be reactivated, or to be totally deactivated if slicers are in another sheet away from table's sheet.
2- If I run advanced filter outside the sheet where the table exists, it shows the error message mentioned previously.

It's a very weird behavior from excel vba.

If you delete the slicers & then use advanced filter, you can then add the slicers again & it seems to work.

Thanks for your reply,
sure it will work but will require a lot of vba code to add and customize the slicer again.

Not too difficult...

Please Login or Register  to view this content.

Thank you for your concern & reply, I'll apply your code on my main sheet based on my actual slicers No., format, location and size.