Document Inspector Excel

Document Properties and Personal Information a. Document properties also known as Metadata (Data about data. Such as the Author of the document, the date that the document was created, and the location on a computer or network that the document was created). Custom XML Data a.

• In this article. Represents a collection of DocumentInspector objects. The DocumentInspectors collection is part of the Document object in Microsoft Word, the Workbook object in Excel, and the Presentation object in PowerPoint. A DocumentInspectors collection contains multiple DocumentInspector objects, one for some built-in options and each installed custom Document Inspector.
• 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). This is available in Excel, Word, and Powerpoint.

/en/excel2016/track-changes-and-comments/content/

Introduction

Before sharing a workbook, you'll want to make sure it doesn't include any spelling errors or information you want to keep private. Fortunately, Excel includes several tools to help finalize and protect your workbook, including DocumentInspector and the Protect Workbook feature.

Optional: Download our practice workbook.

Watch the video below to learn more about inspecting and protecting workbooks.

Document Inspector

/en/excel2016/track-changes-and-comments/content/

Introduction

Before sharing a workbook, you'll want to make sure it doesn't include any spelling errors or information you want to keep private. Fortunately, Excel includes several tools to help finalize and protect your workbook, including DocumentInspector and the Protect Workbook feature.

Optional: Download our practice workbook.

Watch the video below to learn more about inspecting and protecting workbooks.

Document Inspector

Whenever you create or edit a workbook, certain personal information may be added to the file automatically. You can use Document Inspector to remove this information before sharing a workbook with others.

Because 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.

To use Document Inspector:

1. Click the File tab to access Backstage view.
2. From the Info pane, click Check for Issues, then select InspectDocument from the drop-down menu.
3. You may be prompted to save your file before running Document Inspector.
4. Document Inspector will appear. Check or uncheck boxes, depending on the content you want to review, then click Inspect. In our example, we'll leave everything selected.
5. The inspectionresults will appear. 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.
6. When you're done, click Close.

Protecting your workbook

By default, anyone with access to your workbook will be able to open, copy, and edit its content unless you protect it. There are many different ways to protect a workbook, depending on your needs.

Excel Personal Information Document Inspector

To protect your workbook:

1. Click the File tab to access Backstage view.
2. From the Info pane, click the Protect Workbook command.
3. In the drop-down menu, choose the option that best suits your needs. In our example, we'll select Markas Final. 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.
4. A dialog box will appear, prompting you to save. Click OK.
5. Another dialog box will appear. Click OK.
6. The workbook will be marked as final.

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

Document Inspector Excel Mac

Challenge!

Document Inspector Excel 2010

1. Open our practice workbook.
2. Use Document Inspector to check the workbook and remove anything it finds.
3. Protect the workbook by Marking As Final.
4. When you're finished, your workbook should look something like this:

Excel Document Inspector Error Message

/en/excel2016/intro-to-pivottables/content/