#What is document inspector in excel how to#
#What is document inspector in excel series#
#What is document inspector in excel windows#

In case you get in trouble for revealing confidential information because you thought that Document Detector also took care of that matter, keep in mind that Microsoft will not be liable for that.įor more information about the Document Inspector, check out Microsoft’s support page for Excel, Word and PowerPoint. “For example, in Excel you can put data in a far off row or column that you might not see when casually reviewing the spreadsheet, or in Word or PowerPoint, you could cover some data with a picture and forget it’s there.”Īs the official Microsoft blog points it out again, remember that Document Detector does not replace legal review.

#What is document inspector in excel how to#

They will appear in an update in early 2015.”Īlthough the new features improve Document Detector, if you work with sensitive information, keep in mind that some items are undetectable simply because Document Detector was not designed to detect them. How to check for non-phantom links Go to the Insert Name Define menu Select each Name to see what is in the Refers To box If any of these names is. In Excel, we are unable to print the hidden information that is removed by Document Inspector. Or they can be associated with a conditional format. They could be associated with named ranges - those are only slightly hidden. They could be associated with formulas, in which case they do show up. “Some of the new inspectors may not show up in Excel 2010 with the November and December updates for Office 2010. The Document Inspector displays different sets of Inspectors in Office Word 2007, Office Excel 2007, and Office PowerPoint 2007 to enable you to find and remove hidden data and personal information that is specific to each of these programs. Re: Document inspector says External Links found, but cannot find links. Also, the official Microsoft blog informs us: Timelines and surveys are not supported in Excel 2010, therefore Document Inspector detects them only in Excel 2013. This article introduces 5 methods to see, change and remove the metadata of your Excel file.

What is this warning and how I can remove this message What are personal information that exist in my Excel.

PivotTables, PivotCharts, Cube Formulas, Slicers and Timelines* that cannot be removed by the Document Inspector.

First, it tries to automatically remove the private or hidden content from the document and if it fails, then you get an alert. This is how the Document Inspector works. This is why you should check the documents or the metadata (document properties) before you share them publicly. This sensitive information is important because it can reveal details about the presentation or your company that you do not want to share with other people when you share your Excel, PowerPoint or Word documents. Also known as the “Check for issues tool”, Document Inspector checks your Office documents for items that may contain personal or hidden information.

#What is document inspector in excel series#

Microsoft Office 20 now benefit from a series of new Document Inspector features. You use these check boxes to indicate the items you want the.

#What is document inspector in excel windows#

Home › Windows › Microsoft Adds New Features to Document Inspector in Excel, PowerPoint and Word Excel displays the Document Inspector dialog box, which is just a series of check boxes.