Is there a script can remove 3 years ago. You may get warning message about the Document Inspector when you want to save Excel file. The advantage of this function is that you gain a comprehensive impression of all the issues – not only the metadata itself – but also other possibly confidential content. Excel VBA: How To Remove Document Inspector Warning Include Personal Information. Unfortunately, the Document Inspector for many cases doesn’t provide further information (like the actual author name) but just offers to remove them. After the usually quick analysis, Excel shows you the results and offers to remove most of the issues.

Click on “Check for Issues” and then on “Inspect Document”.Alternatively press Alt and then F on the keyboard. Open your Excel file in Excel and click on “File” in the top-left corner of the window.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. Not only metadata, but anything possible confidential is found and can be removed with just a few clicks. Re: Document inspector says External Links found, but cannot find links. Excel provides a function to check your file for you. This method is especially useful if you want to remove all metadata before sharing your Excel file. Please take your time to try the suggestions and let me know the results at your earliest convenience.The Document Inspector can check and remove various hidden information and metadata. If you want to print all the information, you might need to view youĭocuments by not using Document Inspector, and show all the data.įor more information about how to print Excel worksheet, refer to the following article:

In Excel, we are unable to print the hidden information that is removed by Document Inspector. 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 Inspectors are specific to individual Office programs. The Document Inspector includes several different Inspectors that you can use to find and remove different kinds of hidden data and personal information.

Where is document inspector in excel