Share Excel file with different filter view in SharePoint.

I am using office 365.

I shared my Excel file in Sharepoint with many people. Let say I shared with

• Person A
• Person B
• Person C

Now, I have One column, Header is "Department". In this column, I have below value:-

• Department IN
• Department BD
• Department US
• Department UK
• Department SG

Now, In department column, I will filter Department IN, Department BD. And This sheet view I will share with Person A, Person A cannot unfilter this column to see other department data.

Again In department column, I will filter Department US, Department UK. And This sheet view I will share with Person B, Person B cannot unfilter this column to see other department data... So on

Can I achieve this solution?

I know I can create individual sheet and share separately. Actually I dont want the solution in that way.

You can programmatically create protected views (not a nice solution though).
If you are working at or for a company, with access to PowerBI, you can use the RLS functionality to have user based views. That is currently the best method to share like you want.