RUN DOCUMENT INSPECTOR EXCEL HOW TO

XML (Extensible Markup Language, a form of code that the newer versions of Microsoft Office use that is Human readable and Machine readable. Such as the Author of the document, the date that the document was created, and the location on a computer or network that the document was created).ДЄ. Document properties also known as Metadata (Data about data. If you have used any collaboration tools (we will talk about these later) it will check for this information. This is a valuable tool for me in cleaning up documents so would like to fix this.ДЄ. Now when I open up Excel the option to Delete Hidden Rows and Columns in the Document inspector is no longer an available option.

I was recently using the Document inspector in Office 2010 and when it reached the Remove Hidden Rows and Columns task Excel crashed. If you are planning to share the workbook, it is always a good idea to run the Document Inspector to review the workbook for hidden data or personal information that might be stored in the workbook itself or its properties (metadata).

RUN DOCUMENT INSPECTOR EXCEL HOW TO

Additionally, I will show you how to inspect for these hidden p.

In this video, I will show you how to set hidden properties such as Title, Tags, Author, etc. When you try to save a workbook, suddenly a pop-up appears saying 'Be careful!Parts of your document may include personal information that can't be removed by the Document Inspector. If you are using Excel 2013, I'm sure you must have encountered be careful Excel warning.

Run document inspector excel