I posted this question on a different topic before I found this forum, and, I am sorry, I don't remember which one.
I have a large workbook that I have just created a dashboard for. I want to create a copy of the dashboard to put in a separate workbook that I can share with coworkers in a shared folder. I don't want the source data to be shared, as it is a large spreadsheet and I don't want to risk accidental edits, etc. I assume that I will have to make new pivot tables and charts for the new dashboard, as I tried to copy the existing ones but could not make new slicers for them.
I have created a new worksheet within the original workbook for the new pivot tables, charts and slicers. When I copy them over to the new workbook, the slicers do not work. Am I doing this right, or is there an easier way?
Thanks,
Tamsh
I have a large workbook that I have just created a dashboard for. I want to create a copy of the dashboard to put in a separate workbook that I can share with coworkers in a shared folder. I don't want the source data to be shared, as it is a large spreadsheet and I don't want to risk accidental edits, etc. I assume that I will have to make new pivot tables and charts for the new dashboard, as I tried to copy the existing ones but could not make new slicers for them.
I have created a new worksheet within the original workbook for the new pivot tables, charts and slicers. When I copy them over to the new workbook, the slicers do not work. Am I doing this right, or is there an easier way?
Thanks,
Tamsh