Hello all, I have a similar question to the one posed in the following posts, but my data sources are different.
https://chandoo.org/forum/threads/how-to-update-a-cube-slicer-based-on-user-input-vba.31942/
I started out with some source code from Mr.Excel and was able to duplicate his results by making a small mockup file but was unable to reproduce the results with the file getting data from two separate cubes. By that time I had added a bunch of debug statements to try and better understand the code.
Eventually, I realized that SlicerItems was not going to work, and I needed to use SlicerCacheLevel.
https://docs.microsoft.com/en-us/office/vba/api/excel.slicercache.sliceritems
Despite my efforts, I haven't been able to adjust the code to work. I have only dabbled in VBA, so any clarification on the differenced between sliceritems, slicercaches, and slicercachelevels would be greatly appreciated. Also any insight on modifying the code would be greatly appreciated.
Thanks,
Luke
https://chandoo.org/forum/threads/how-to-update-a-cube-slicer-based-on-user-input-vba.31942/
I started out with some source code from Mr.Excel and was able to duplicate his results by making a small mockup file but was unable to reproduce the results with the file getting data from two separate cubes. By that time I had added a bunch of debug statements to try and better understand the code.
Sync Slicers in Excel
How can you have a slicer drive two pivot tables if they came from different data sets?
www.mrexcel.com
Eventually, I realized that SlicerItems was not going to work, and I needed to use SlicerCacheLevel.
https://docs.microsoft.com/en-us/office/vba/api/excel.slicercache.sliceritems
Despite my efforts, I haven't been able to adjust the code to work. I have only dabbled in VBA, so any clarification on the differenced between sliceritems, slicercaches, and slicercachelevels would be greatly appreciated. Also any insight on modifying the code would be greatly appreciated.
Thanks,
Luke