Excel Tip - Defend A Pivot Desk However Enable Entry To A Slicer
When you've got spent a major period of time on a spreadsheet resolution, probably a dashboard, bought every little thing simply as you need it, then you definitely undoubtedly are not looking for your customers by chance (or in deed intentionally) transfer, delete, exchange or change information which might have an effect on your evaluation and information presentation on you unfold sheet.
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 major methods to do that is through Pivot slicers to present management of the dashboard to customers in order that they discover and use it to establish traits and make enterprise choices.
This text will take you step-by-step organising your work sheet safety however enable entry to Pivot Desk slicers to keep up the integrity of your work sheet information and performance. There are a couple of 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 in your Pivot Desk
- Click on wherever 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 Measurement and Properties Choices
- Drill down into Properties
- Unlock the slicer by un ticking or de choosing the Locked possibility
- Hit Shut to complete the method
- This unlocks the slicer
- Repeat for as many slicers as you require in your work sheet
Stage 2. We now flip our consideration to the work sheet piece of the answer
- Hit the Evaluate tab on the Excel Ribbon ( Excel 2010)
- Within the Adjustments Group choose to Defend Work Sheet
- Within the Enable All Customers Of This Worksheet To,un tick all choices other than Choose Unlocked Cells and Use Pivot Desk Experiences
- Enter a password if you wish to so as to add additional safety to your work sheet. That is undoubtedly really helpful as you could have made an effort to lock down the spreadsheet and simply enable customers to govern the pivots through slicers.
The customers will solely have entry to the Pivot Desk Slicers subsequently guaranteeing your work sheet will not be altered or tampered with in any manner, specifically your information and constructions.