Chapter 8
Publishing Your Dashboard
Section 1
Cleaning Up and Locking Down
Normal 0 false false false EN-IN X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;} Your dashboard is complete, but we need to lock down the information that we don't want the users to focus on. We can do this by preventing the modification of cells and hiding sheets. - Right-click on each sheet that is not meant to be displayed to the end user and click on Hide - Right-click on cells and objects that the user needs to be able to use/modify (for example, slicers and input cells), choose Properties, and uncheck the Locked box - Right-click on the remaining sheet tabs in your dashboard and choose Protect Sheet, and optionally use password protection