Run-time error: Methods 'add' of object 'SlicerCaches' failed

[Yuqian]

Hi All,

The method SlicerCaches.Add() worked in Excel2010 but not in Excel2016. So i tried SlicerCaches.Add2() in Excel2016 and got the same error message: Run-time error: Methods 'add2' of object 'SlicerCaches' fail. I dim SC as Slicercache then add slicers to it. i tried to record macro then copy and paste it to my code. Didn't work. I also couldn't insert slicer manually to pivot table.

Anyone could help?

Thank you,
Best,

Yuqian