Forum Discussion
Slicers not connecting to pivot tables - HELP!
Hello! I am building my knowledge in pivot tables and building interactive dashboards. At the very end of my dashboard, I am unable to connect my slicer to all the pivot tables. I am unsure why!
I have attached my Excel file with this message. In the worksheet "Data-Accident", the dataset is available. In the worksheet "Dashboard", when you click on the slicers, you can see that, 'MONTHLY TREND' and 'Casualties buy Road Type' does not change. https://docs.google.com/spreadsheets/d/10tx-CPSStU3ZHcQEf2l_gNVEe0P-eiNY/edit?usp=sharing&ouid=109379404407490216342&rtpof=true&sd=true
2 Replies
- SanJims First the data source has changed in the pivot table hence it doesn't recognize those tables to connect them with the slicer hence the issue and in the dashboard the slicers are not connected to the pivot tables hence when changed they do not change. Once you create the pivot tables again the problem will get fixed.
SanJims The file in your link doesn't open. At least not for me. Not even after quite a long wait. So I gave up.
Make sure that all pivot tables share the same pivot cache. More about that in the link below.
