where is the document inspector in excel 2016

#Where is the document inspector in excel 2016 how to#
#Where is the document inspector in excel 2016 free#

Tips: If this option is gray and you can’t enable it, click Document Inspector. Step 2: Select Privacy Options, then enable Remove personal information from file properties on save. Click Options, select the Trust Center, then click Trust Center Settings. With the document, workbook, or presentation open that you want to check: Click on File in the top. In the Document Inspector dialog box that appears, select the checkboxes for the types of data you want the Document Inspector to find and remove from the document. Then click the Inspect Document command in the drop-down menu that appears. You can set the Office file that you are working on to automatically remove meta data every time the file is saved. View Metadata in Word, Excel, or PowerPoint. To the right, click the Check for Issues drop-down button. Option 2: Enable Document Specific Setting to Remove Personal Data Step 5: Review the results of the inspection in the Document Inspector dialog box.Ĭlick Remove All next to the inspection results for the types of hidden content that you want to remove from your document. Step 4: In the Document Inspector dialog box, select the check boxes to choose the types of hidden content that you want to be inspected. Click the Check for Issues > Inspect Document. Step 3: In the copy of your original document, click on File tab. Step 2: Click Save As, then type a name in the File name box to save a copy of your original document. Step 1: Open the document that you want to inspect for hidden data and personal information.

#Where is the document inspector in excel 2016 free#

Microsoft offers a free Document Inspector for removing hidden data or sensitive information before you share a Microsoft Office file. Option 1: Use Document Inspector to Clear Hidden Information

Option 2: To remove personal information with Document Specific setting.

Option 1: To remove the hidden personal data with Document Inspector.

#Where is the document inspector in excel 2016 how to#

Here we will show you how to find and remove hidden data and personal information from Office documents. This information might not be immediately visible when you view the document in Office program, but it might be possible for other people to view or retrieve the information. The 2007 versions of Word, Excel, PowerPoint, and Publisher list an option to remove personal information from file properties on save (this may be grayed out), as well as a Document Inspector.

Several types of hidden data and personal information can be saved in a Word/Excel/PowerPoint document. The Document Inspector scans Excel workbook files for such metadata as. How to Clear the Hidden Personal Data in Office Document Microsoft Office Excel 2016: Part 1 and Part 2 courses to help you get the most.