Hello again. I'm getting an error (end/debug) message thrown when I change names of the slicers, both in the Data sheet and on the Slicer itself, and then try to update the PT or Reset the PT.
The error is showing on Sheet2 (BuildMyBOM). Select any of the Items to the left and then select Reset. The line that is being highlighted is:
If Not ActiveWorkbook.SlicerCaches(SlicerName).SlicerItems.Item(1).Value = "N/A" Then
I’ve updated the Data sheet, I’ve updated the slicers, I’ve updated the code to the best of my abilities. I’m not sure where I’m going wrong. Would greatly appreciate if someone could take a look at it for me and provide some insight. Tks.
Bookmarks