Row Level visibility based on Windows Login?

[iklein]

I have a spreadsheet with multiple salespeople listed. Each row has a different seller's name and other sales data. It has very private data related to each sellers performance and pay. Is there a way for me to share this file with all sellers listed without going through all the work of parsing out individually? Can I add something that uses the seller's Windows login credentials... which I have in a column for each seller... that would restrict visibility to all other data except for theirs?
I'm using Excel 2016.

Thanks,
Kevin

 

[Fluff]

Excel is not secure in any shape size or form.
The only way to ensure your data is kept private is not to share it.
So I would advise splitting the data into separate workbooks.

 

[iklein]

Isn't there anything I can do with Row Level Security and/or VBA to restrict visibility based on user name or email? Or is this something I would need to build with PowerBI?

 

[Fluff]

You can do things with VBA/sheet protection, but it is NOT secure & can easily be broken, by anyone who can search the internet.