I would like to be able to secure parts of my data whereas allow other sections of it to be exportable. Currently it seems I can only lock the whole file or not at all.


What I would like to achieve is to have a report which has multiple types of data such as location of venues & sales transaction figures. As you can imagine transaction information can be highly sensitive and needs to be protected.

As such I would like to secure only the data regarding Sales Transactions but allow users to be able to export out a list of locations.

If I am able to restrict by one of the following then it would pretty much cover what I need.

- Field Contents i.e. If Transactions data then Hide
- Block Particular Columns from being Exported i.e. If Columns are Costs or Revenue
- Disable Export View function per tab or individual view