#Document inspector in excel opening how to#
#Document inspector in excel opening download#

The Document Inspector window will appear, allowing you to select the types of content you want to search for. Select the “Check for Issues” tile, then “Inspect Document”:Ī pop-up window will confirm this action and ask you to save the file. Open a document and select “File”, then the “Info” tab.

#Document inspector in excel opening how to#

To learn how to inspect a document, workbook, or presentation, keep reading! This is available in Excel, Word, and Powerpoint. The document inspector wizard in Office 365 can help ensure your document is clean of hidden properties, personal information, and other items that could cause issues before you send or publish it (think macros or custom XML data). en/excel2016/intro-to-pivottables/content/

When you’re finished, your workbook should look something like this:.

Protect the workbook by Marking As Final.

Use Document Inspector to check the workbook and remove anything it finds.

If you want to prevent people from editing it, you can use the Restrict Access option instead. Marking a workbook as final will not prevent others from editing it.

A dialog box will appear, prompting you to save.

Marking your workbook as final is a good way to discourage others from editing the workbook, while the other options give you even more control if needed. In our example, we’ll select Mark as Final.

In the drop-down menu, choose the option that best suits your needs.

From the Info pane, click the Protect Workbook command.

There are many different ways to protect a workbook, depending on your needs. In our example, we can see that our workbook contains comments and some personal information, so we’ll click Remove All on both items to remove this information from the workbook.īy default, anyone with access to your workbook will be able to open, copy, and edit its content unless you protect it. In our example, we’ll leave everything selected.

Check or uncheck boxes, depending on the content you want to review, then click Inspect. You may be prompted to save your file before running Document Inspector.From the Info pane, click Check for Issues, then select Inspect Document from the drop-down menu.Click the File tab to access Backstage view.You can use Document Inspector to remove this information before sharing a workbook with others.īecause some changes may be permanent, it’s a good idea to save an additional copy of your workbook before using the Document Inspector to remove information. Whenever you create or edit a workbook, certain personal information may be added to the file automatically. Watch the video below to learn more about inspecting and protecting workbooks.

#Document inspector in excel opening download#

Optional: Download our practice workbook. Fortunately, Excel includes several tools to help finalize and protect your workbook, including Document Inspector and the Protect Workbook feature. en/excel2016/track-changes-and-comments/content/ Introductionīefore sharing a workbook, you’ll want to make sure it doesn’t include any spelling errors or information you want to keep private. Lesson 26: Inspecting and Protecting Workbooks