Dashboard private performance data sharing

[Brianmay43]

Hi! I have a workbook that has a dashboard of my organizations performance data separated by individuals. I have a slicer that includes the names of the individuals so I can toggle in between everyone’s performance metrics. Is there a way that I can somehow password protect or reorganize my slicers so that I can share their own day with them but not be able to view other individuals private performance data at the same time.

Thanks!

 

[dmt32]

Hi,
Welcome to forum
Excel security is very weak and anyone with a good understanding can circumvent any attempts you make to restrict viewing of the data.

As a suggestion, if those needing access to your workbook have access to it over your corporate network then one solution maybe would be to provide each of your users with a template copy of the workbook. Using VBA, these template workbooks would then filter and copy only the user’s data from your master workbook.

The filtering can be done by using the network username (log-in name) of a user which would provide a modest level of security to ensure that they can only get to see their data.

However, to achieve this approach VBA would be involved & this would depend on your level of understanding in the subject & if your organisation permits its use?

Others here may have alternative suggestions

Hope helpful

Dave