But it is suggested that you save your file before you start telling the Inspector to remove any information. You are then asked if you want to save the document before inspection or not. In Excel 2007 you have the Office Button and then you go to Prepare and you’ll find this option there. To check for these, go to File > Check For Issues > Inspect Document.
A great tool to use before distributing workbooks. That’s where you can use the Inspect document feature. To find all this out manually can be time consuming.
Some hidden information can be deliberate whereas some might be unintentional. Normally, these Excel files are quite large and contain many tabs and it’s not always clear if there is hidden information such as comments, personal information, hidden rows and objects in the file.
#How to remove document inspector in excel update#
In most cases when you start to work at a new company, you take over the existing Excel workbooks of your predecessor and continue to update and expand on these.