Proetection keep you from viewing data in filtered rows.

[cogswel__cogs]

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?

 

[baitmaster]

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]

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.

.