Proetection keep you from viewing data in filtered rows.

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
168
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:

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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
 
Upvote 0
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.

.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,981
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top