In case you have spent a major period of time on a spreadsheet resolution, presumably a dashboard, acquired every little thing simply as you need it, then you definately positively are not looking for your customers unintentionally (or in deed intentionally) transfer, delete, substitute or change information which may have an effect on your evaluation and information presentation on you unfold sheet Vegetable Slicer with 3 Interchangeable Blades B07P6G5L35.
You do nonetheless need customers to make use of your work e-book and work together with it, particularly in such spreadsheet options as interactive dashboards. One of many fundamental methods to do that is by way of Pivot slicers to offer management of the dashboard to customers in order that they discover and use it to determine developments and make business choices.
This text will take you step-by-step establishing your work sheet safety however permit entry to Pivot Desk slicers to take care of the integrity of your work sheet information and performance. There are just a few phases to this course of.
This assumes that you’ve got already created a Pivot Desk and a corresponding slicer management.
Making a slicer is simple on your Pivot Desk
- Click on anyplace in your Pivot Desk
- In Pivot desk Instruments – Choices – and Design tab will seem
- Within the Choices Tab- in Sport And Filter- Group hit Insert Slicer
- Within the dialog field that seem choose the fields you need use to filter your Pivot Desk.
- Hit OK- you now have a slicer
Stage 1 is to make sure that the Pivot Desk Slicer is ‘unlocked’.
- Firstly Proper click on in your slicer and choose Dimension and Properties Choices
- Drill down into Properties
- Unlock the slicer by un ticking or de deciding on the Locked possibility
- Hit Shut to complete the method
- This unlocks the slicer
- Repeat for as many slicers as you require on your work sheet
