How to restrict access - create login accounts to view a sheet and display filtered data

**bnevena** · 07-05-2019, 09:34 AM

Hello Forum Fellows!

I'm struggling with creating access levels in Excel. Is it possible to create many accounts with username and password and then based on the account to display only filtered data?

I have attached a sample file. The point is to create a logon mask. Then Account 1 with password 1 will open the file but see only assignees and tasks for Account 1. The rest of the data will remain invisible. Same for Account 2 etc.

Could you please suggest approaches how to achieve this in a simple way?

**CK76** · 07-05-2019, 09:52 AM

Possible. But really not secure.

Excel isn't meant as secure data sharing tool and once user has the workbook open, user with enough curiosity can break almost all protections applied to the data.

Only strong protection is workbook encryption.

If it is vital to secure data between user access level... consider using some other tool, or publishing separate report for each individual.

**Marc L** · 07-05-2019, 09:52 AM

Hi !

See samples in thread of this forum but I do not think about any simple way as Excel was not designed for …
And do not forget any protection can be easily bypassed !

**bnevena** · 07-05-2019, 10:18 AM

Thank you for the replies! Is there any difference if the file is uploaded in SharePoint?

**CK76** · 07-05-2019, 10:33 AM

Not really. If data is contained within workbook, it's quite easy to access.

From the sample workbook, it's just a list. Why not leverage SharePoint's security feature to limit access to data?
Use SharePoint list and restrict "View" for each user to their assigned item(s).

**bnevena** · 07-08-2019, 02:46 AM

Thank you, CK76! Much appreciated.

How to restrict access - create login accounts to view a sheet and display filtered data

LinkBack

Thread Tools

Rate This Thread

Display

How to restrict access - create login accounts to view a sheet and display filtered data

Re: How to restrict access - create login accounts to view a sheet and display filtered da

Re: How to restrict access - create login accounts to view a sheet and display filtered da

Re: How to restrict access - create login accounts to view a sheet and display filtered da

Re: How to restrict access - create login accounts to view a sheet and display filtered da

Re: How to restrict access - create login accounts to view a sheet and display filtered da

Thread Information

Users Browsing this Thread

Similar Threads

Create Named Range Based On Filtered List/ Criteria dependent on User Login

VBA to copy filtered data from excel sheet to access table

How to access specific answers addressed when one sees "please login to view results?"

Create copy of Excel sheet on another server to view live data

[SOLVED] How do I create an automatic list in an excel sheet with filtered data from another sheet?

Automatically display filtered data on other sheets based on the first sheet?

Filter, copy filtered data into another sheet, create a file of that sheet..

Bookmarks

Bookmarks

Posting Permissions