Hi
I create a report on word, and often include graphs which are copy and pasted from an excel workbook.
I'd like to create a dashboard with slicers to either
a) be included in the word document if possible, they are pivot charts.
b) send as an accompaniment to the word document.
Either way, I'd prefer that only the dashboard is seen and not the raw date or pivot tables but can't seem to find a way to do this? I attempted to attach as a link but can only select the entire work book. Also, one of the recipients is external, would they still be able to use the slicers?
Thoughts much appreciated.
I create a report on word, and often include graphs which are copy and pasted from an excel workbook.
I'd like to create a dashboard with slicers to either
a) be included in the word document if possible, they are pivot charts.
b) send as an accompaniment to the word document.
Either way, I'd prefer that only the dashboard is seen and not the raw date or pivot tables but can't seem to find a way to do this? I attempted to attach as a link but can only select the entire work book. Also, one of the recipients is external, would they still be able to use the slicers?
Thoughts much appreciated.