Hi All,

I'm wondering whether it is at all possible to only display data (or filter on data), based on a specific access code for a user, in a pivot or slicer

Context:
I am building a Pivot with Slicers to display various strings of data for different users. However I do not want the different users to view each other's data. Is there a way to enforce users to enter a unique access code and then only display data related to that unique access code? This should be true for the slicer as well, displaying only items available for the unique access code on the slicer. I don't want to duplicate the data set for each user as it creates too many sheets to update, which will be a once a week task.

I have thought about a text box that pop up on opening the workbook and using the entered code to filter the data, but the data in the pivot will not reflect just this filtered data set for selection and viewing, but the whole data set.

If this is possible how would I go about setting something up to achieve this? Any suggestions and or ideas would be appreciated.

Kind Regards