how to disable document inspector in excel

#How to disable document inspector in excel how to

Here you can already see some information about your document.

The Properties pane is shown on the right-hand side. This method allows you to see the information about your document right in the worksheet. If you don't know where to find the information about your document in Excel 2016-2010, here are three ways to do it. So when you want to add a file to the document library, you have to enter the values for any properties that are required, or correct any properties that are wrong. A person who creates a document library can set some document library properties and rules for their values. Document library properties refer to documents in a document library on a Web site or in a public folder. Properties for your organization are properties specific to the organization. They allow you to add other properties to your Office document. Custom properties are user-defined properties. Some properties that are unique to the document at the application level such as the number of pages, words or characters in the document or the version of the application are automatically updated by the document content. Automatically updated properties include the data about your file that are controlled and changed by the system such as the file size and the time the document was created and modified. You can assign your own text values for these properties to make it easier to find the document on your PC. They contain basic information about the document such as title, subject, author, category, etc. Standard properties are common to all Office 2010 applications.

#How to disable document inspector in excel how to

Let's get it started! :)īefore starting to learn how to view, change and remove document properties (metadata) in Excel, let's clear up what kinds of properties an Office document can have. In this article you will find a detailed guide how to view and change the document properties, protect your document from any modifications and remove personal information from your Excel worksheet. In these last two versions they are hidden deeper, but it won't take you much time to dig them out. This is what happened to the document properties in Excel 2010 / 2013. In this article you'll also learn how to protect your document from any modifications and remove personal information from your Excel worksheet.ĭo you remember your feelings when you just started to use Excel 2016 or 2013? Personally I sometimes felt angry when I couldn't find the necessary tool or option at the place where they were in the previous Excel versions.

Once you exit the Document Inspector, verify that the author metadata was removed.The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel 2019, 20. This is another place where you would not remove it. This is an example from an Excel spreadsheet where the tracking bug is in a hidden sheet. I will choose to leave this there since I know all it contains is the tracking bug. In this case, I put it in the document header so it makes sense that the Document Inspector is showing that there is a header. Use your discretion on which ones to remove but keep in mind where you stored your tracking bug. Scrolling down, you may see other items with Remove All buttons next to them. Choose Remove All next to Document Properties and Personal Information.Choose Inspect in the dialog window that appears.From the File->Info menu, click Check for Issues.However, if you want to clear the data this is how. The instructions below were made with Microsoft Office 2013 for Windows. If it is something generic or purposely misleading you may wish to leave it as-is. Choose the File->Info menu and you can see what value is set as the author. When you save a file in Microsoft Office some metadata about you is stored, such as the author name. But don’t let all that effort go to waste by leaving metadata in that could lead back to you. In my last two posts I showed how to insert tracking bugs in both.