I hope someone can help with this issue. Using excel 2013 and I have a macro that triggers / synchronises several slicers that select the data in many pivots.
The macro then goes on and renders and publishes the report in PDF format. I have hidden all sheets except the "option selection page"...