In my work I sometimes need to build dashboards based on pivot tables linked to cubes. To define common settings, like the last 12 months, I have been manually selecting them in a slicer called "slicerMonths".
Now I must to send the dashboard to managers, Excel-illiterate people that will only define the current month in a cell (ex: "November 2016", meaning the dashboard will show info from "November 2015" until "November 2016").
I have created a 13-cell area named "Last12m" where the months from Nov.2015 until Nov.2016 are shown. Is there a way with VBA to update the slicer selection with this information? -- all the examples I've seen so far were based on "regular" pivots, not cubes.
Many thanks.
Now I must to send the dashboard to managers, Excel-illiterate people that will only define the current month in a cell (ex: "November 2016", meaning the dashboard will show info from "November 2015" until "November 2016").
I have created a 13-cell area named "Last12m" where the months from Nov.2015 until Nov.2016 are shown. Is there a way with VBA to update the slicer selection with this information? -- all the examples I've seen so far were based on "regular" pivots, not cubes.
Many thanks.