Excel Dashboards and Reports for Dummies, 3rd Edition

Chapter 14

Sharing Your Workbook with the Outside World

In This Chapter

Controlling access to your dashboards and reports

Displaying your Excel dashboards in PowerPoint

Saving your dashboards and reports to a PDF file

Publishing your dashboards to the web

Let’s face it: You’re not making these dashboards and reports for your health. At some point, you’ll want to share your handiwork with others. The focus of this chapter is on preparing your dashboards for life outside your PC. Here, I help you explore the various methods of protecting your work from accidental and intentional meddling and show how you can distribute your dashboards via PowerPoint, PDF, and the web.

Protecting Your Dashboards and Reports

You’ve put in a ton of hours getting your dashboard and reports to work the way you want them to. The last thing you need is to have a clumsy client or an overzealous power user botching up your Excel file.

Before distributing any Excel-based work, you should always consider protecting your file using the protection capabilities native to Excel. Although none of Excel’s protection ...