Hey there…I have a slicer linked to multiple pivots whose data connection is an olap cube.
My goal is to change the olap cube connection and then change the data sources for all pivots and still attempting to keep the slicer in tack.
Here was my approach: Add the new olap cube connection to the workboork. Alter the slicer report connections by unchecking the first (of the multiple) pivots. Change the data source for the first pivot to the newly added data connection. Refresh. The issue is when I go back to the ReportConneciton of the slicer I no longer see the first Pivot (the newly reconnected one) as an option.
Is this doable rather than having to rebuild a new slicer based of the pivot with the new data connection.
Thanks
My goal is to change the olap cube connection and then change the data sources for all pivots and still attempting to keep the slicer in tack.
Here was my approach: Add the new olap cube connection to the workboork. Alter the slicer report connections by unchecking the first (of the multiple) pivots. Change the data source for the first pivot to the newly added data connection. Refresh. The issue is when I go back to the ReportConneciton of the slicer I no longer see the first Pivot (the newly reconnected one) as an option.
Is this doable rather than having to rebuild a new slicer based of the pivot with the new data connection.
Thanks