Geoff has attended:
Excel Intermediate course
Office 365 End User course
Spreadsheets
So I have to send monthly reports and one of the tables is for RASSO cases for all 3 police areas. My question is how to I tailor the report to close off the data from the other police areas so that only one set is showing?
RE: spreadsheets
Hi Geoff,
Thank you for the forum question.
The safest way of making sure that no one can see more information in a report that you want is to split the data set.
You can do this if you are working with Pivot Tables, the advanced filter, or Power Query. You can also do it manually,
You have more options but they are not 100% safe. You can, if you have the right knowledge, explore all the data, even that you try to protect the data, if all the data is in the file.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
