#How to use document inspector in excel how to#

Might want to create and save a copy of the document before you inspect, remove and send, because it may remove elements that you want to keep in your original.Īs you work, here is what starts to accumulate about your document and you (or the user who is working on it).Ĭlick File tab to display the Info screen (Backstage) with the Properties of the current document (left screenshot): NOTE: Document Inspector tends to be an all or nothing thing. On the other hand, if this is confidential or going to another department, or worse yet, to a client or outside organization, there could be a problem Houston! If the document is not leaving your computer or office, it may not be an issue to have unexpected details revealed about the creation path and timeframe for editing, how many revisions and more. There are positive uses for this information and even for creating our own custom Document Properties, but we’ll cover that in a future blog as this is about protecting your information in Word, Excel and PowerPoint. We have enough to handle just getting the document to be correct and look the way we want to present it without worrying about broadcasting sensitive data!

#How to use document inspector in excel how to#

This blog reveals how to inspect and remove sensitive document properties with Document Inspector.

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.It may come as a shock to some just how much information Microsoft collects in Document Properties during the creation of a file. If the Document Inspector encounters errors during the operation, the module is flagged, displays an error message, and the data for that module does not change. If you choose to remove the data for a given module, the dialog box displays descriptive text that indicates whether the operation was successful or not. If the module does not find data, the dialog box displays a message to that effect. If a given module finds data, the dialog box includes a Remove All button that you can click to remove that data. Use the Document Inspector dialog box to select the type or types of data to find in the document.Īfter the modules complete the inspection, the Document Inspector displays the results for each module in a dialog box.

Document properties and personal information this includes metadata, SharePoint properties, custom properties, and other content informationĬhoose the File tab, and then choose Info.

Comments, revisions, versions, and annotations.

Document properties and personal information.

The Document Inspector includes the following built-in modules. The Document Inspector has modules that help users inspect and fix specific elements of a given document. The Document Inspector in Word, Excel, and PowerPoint includes the following enhancements. We recommend that you run the Document Inspector before you sign a document or invoke IRM on a document.Īs a developer, you can use the Document Inspector framework to extend the built-in modules and integrate your extensions into the standard user interface.

Microsoft does not support the automatic removal of hidden information for signed or protected documents, or for documents that use Information Rights Management (IRM).