I have a main pivot table with 4 slicers and one of the slicers is no longer pulling through one value. For example the column is filled with people's names (where you can only select set names), approximately 50 different names. The slicer no longer brings through one of the names, just has 3 dots showing and on the pivot table it is completely blank. The other linked data appears to be correct but no name showing. I've been through the whole base data to review for any obvious data entry issues and resolved them where I have observed them but this has not helped. This spreadsheet does have broad access for data entry, currently stored in SharePoint.
Any ideas to assist would be greatly appreciated 🙂
Updated to add a visual!