O'Reilly logo

Excel 2010: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Preparing Your Workbook

Before you go ahead and release your workbook into the wild, you may want to perform a few last-minute tasks (things like giving your spreadsheet a descriptive name, checking whether it's encrypted, and so on). Excel helps you out by grouping some of the most common collaborative-prep tools in backstage view. To see them, choose File→Info (Figure 25-1).

The following sections walk you through the most important options in the File→Info page and show you how they can prepare your spreadsheet for a wider audience.

Note

The only section you won't consider is the Versions section, which lets you recover old versions of a workbook after you make changes. This feature, which doesn't have anything to do with document sharing, is discussed on AutoRecover.

Before your workbook goes out the door, you may want to consider switching on document protection, scouring your spreadsheet for potential issues, and changing its properties. File→Info page in backstage view is a springboard for all of these tasks.

Figure 25-1. Before your workbook goes out the door, you may want to consider switching on document protection, scouring your spreadsheet for potential issues, and changing its properties. File→Info page in backstage view is a springboard for all of these tasks.

Workbook Protection

The File→Info page is split into several sections, each with a large button. The first button, named Protect Workbook, helps you to prevent other people from changing things they shouldn't in your workbook.

When you click the Protect Workbook button, a menu pops up with a list of options. You've seen some of these options in previous chapters. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required