Hello.
There is a report that currently is being used in my company that has 3 pivots and a few slicers in the main page. Whenever I modify the slicers, they alter the pivots as well.
I'm trying to do that with VBA, I can do the pivot, and the slicers, but the slicers modify the data page where they come from, not the pivot.
I've been trying to link them to the pivots, my process so far has been creating the pivot by VBA and then try to add the slicers but somehow (I don't understand why) the slicer option is disabled, and if trying to code it, it shows errors.
Any help will be appreciated.
Thanks in advance.
Bookmarks