Excel 2016 slicer item now has wrong name but refers to correct item in pivot table? Very strange

[codeliftsleep]

This has to be the strangest bug I've ever seen in Excel.

I created 2 slicers that control numerous pivot tables. In VBA, I check who the user is on login and then loop through the slicer names to set their name as the only one marked as true. Simple code right--the same code I have done in numerous other workbooks and never had an issue. Wrong...somehow now my name has replaced another person's name on the slicer item, and I have no data in the data source and never have(there is no possible way my name should be in the slicer). Even stranger is the pivot table filter is showing the correct name in there but the wrong name in the slicer. When I click my name in the slicer it correctly filters the pivot table for the correct person, ie somehow in the process of doing this my name has replaced this person's in the slicer but it is linked to the other person's name in the pivot table. Obviously I cannot rename the slicer item because it is a read only property.

Even stranger is on some of the other pivot tables the slicer is connected to, my name has replaced his in the filter also, so he no longer appears but my name still refers to his data---ie, my name replaced his, but it still pulls his data when I filter it. I have tried everything from refreshing the data to deleting the slicer and recreating it to reimporting the data to closing and opening the workbook again...nothing has worked...the issue still remains.

I also have it set to only loop through the code and redo the slicers if it is NOT me logged in...

I am at a loss here. It's not feasible to redo all the pivot tables, there are simply too many of them. Any suggestions as to how this could have happened and how to resolve it?? I have searched on google and haven't found anyone posting about this issue...

 

[RoryA]

It sounds to me as though you’ve changed the caption for the item somehow - probably in your code. Hard to be sure without seeing the workbook.

 

[codeliftsleep]

It sounds to me as though you’ve changed the caption for the item somehow - probably in your code. Hard to be sure without seeing the workbook.

That's what I thought to but I don't use the caption property at all...and besides its read only, so I don't know how that is possible.

Code is really basic

With ThisWorkbook.SlicerCaches("Slicer_MgrName")
            .ClearManualFilter
            For Each si In .SlicerItems
            
                If si.Name = MgrName Then
                    si.Selected = True
                Else
                    si.Selected = False
                End If
            Next si
        End With

 

[RoryA]

Are you sure you didn’t accidentally overtype a cell in one of the pivot tables at any point?