Report connections for Pivot table slicer doesn

问题:

I have 3 sheets with several pivot tables on each and one sheet with the source data. These 4 sheets were copied directly from another workbook. When I copied the worksheets over the source data for each pivot table was still the original source data sheet in the original workbook. Therefore, I changed each pivot table's source to the copied over raw data sheet. Whilst doing this I had to disconnect all the pivot table slicers in order to be able to change the source.

Now, this is where my problem lies; When I go back to reconnect the slicer only one of the pivot tables shows up in the list, when in fact I need to connect the slicer to several. What do I need to do?

Note: I did all of this using a macro that I created so I am open to using macros.

回答1:

I was able to resolve this issue with the following steps;

1. Delete all slicers

2. Change the Table name:

   

3. For each pivot table, click on change data source button. The new name should already be in there so just press enter. If you didnt delete all slicers it will throw an error, indicating that it is only identifying other pivot tables with the same datasource now.

   

4. Create a new slicer and reconnect to all tables.

Note that step 2 may not be required but that is the workflow that I followed.