![how to use the document inspector in excel how to use the document inspector in excel](https://woodwing.zendesk.com/hc/article_attachments/360064383652/assets-6.52-metadata-report-in-excel.jpg)
A Remove All button allows users to eliminate unwanted information from the document or presentation. xlsx file but everytime it will show 'Be careful Parts of your documents may include personal information that can't be removed by the Document Inspector' I have tried the following code but useless. Use File, Info, Check for Issues, Inspect Document. Select Check for Issues, and after the inspection is complete, a dialogue box displays the results. To look for hidden data in your workbook, run the Document Inspector. The Document Inspector feature is located in Microsoft applications under the File and Info tab. On its sub-menu click Inspect Document, which will. Perform SQL-like queries against the data. Use the Document Inspector in Microsoft Word to inspect annotations, versions, revisions and comments. So: open the document in Word, and go to the File menu and there you will find an Inspect Document menu. To use the Document Inspector in Word after saving a copy of the original document, open the document to inspect. Open the Property inspector (Window > Properties) and do one of the following: Click the folder icon to the right of the Link box to browse to and select a file. Step 2: Select the box next to the AutoSave OneDrive and SharePoint Online files by default option. Select text or an image in the Document window’s Design view. In the resulting dialog, switch to the Save tab. The feature searches hidden text, invisible content, watermarks, headers and footers, and custom XML data in Microsoft Word documents. It’s a good idea to start by checking if the AutoSave feature is disabled under settings. People can use the Document Inspector feature to search, replace and delete unwanted information on off-slide content, presentation notes and invisible on-slide content within Microsoft PowerPoint presentations.
![how to use the document inspector in excel how to use the document inspector in excel](https://www.tutoraspire.com/wp-content/static/ms/excel/images/how-to-convert-excel-to-csv14.png)
I simply enabled the Add-In, restarted excel and the functionality has returned. The modules inspect headers and footers, hidden rows, columns and worksheets, invisible content and document properties, and personal information within Microsoft Excel. In order to bring back this functionality, once in Excel, I had to go to File -> Options -> Add-Ins Then under the 'Manage' drop down at the bottom of this screen I selected 'Disabled Items', there I saw the Hidden Rows and Columns Add-In had been disabled. The Document Inspector feature includes built-in modules that inspect documents for specific elements that may reveal personal data or information that should not be disseminated.