Proetection keep you from viewing data in filtered rows.

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
98
So I am using filters to hide data from users.
Depending on a login password. I un-filter or filter certain rows and then use filter refresh.

However I guess anyone can link to tab on another sheet or file and then just copy up or down and see the filtered rows.

Is there a way to stop this?
 
Last edited:

baitmaster

Well-known Member
Joined
Mar 12, 2009
Messages
2,034
No, sorry

Excel is not a secure medium and you cannot hide anything from an experienced User. If using it to hold sensitive data - commercial, legally protected, GDPR etc - then you MUST take extra care when sharing it. Consider using VBA to generate subsets of results that get written to new files to share with individual Users
 

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
98
Thanks for reply.
I figured that was case. It not an uber security issue so I just took name column moved it and only show it in that row if it is in filtered material.

.
 

Forum statistics

Threads
1,085,513
Messages
5,384,111
Members
401,881
Latest member
Dato

Some videos you may like

This Week's Hot Topics

Top