Spreadsheets

Resolved · Low Priority · Version 365

Mon 21 Feb 2022, 16:41 Delegate Geoff said...

Geoff has attended:
Office 365 End User course
Excel Intermediate 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?

Fri 25 Feb 2022, 09:36 Trainer Jens said...

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

Fri 4 Mar 2022: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

View all Excel hints and tips