I’m gonna show you simple ways of getting around this and finding the information yourself. Some are harder to find because it doesn’t tell you which particular tab and cell they are found. But comments, they could be anywhere in your sheet. Some of them can be obvious, like Document Properties. Now, the downside of this is that it doesn’t tell you exactly where you can find things. It found a hidden worksheet, that’s one, and some invisible content-so two objects that are invisible. Once you click on Inspect you will see a summary of what it finds, such as comments, Author, PivotTable, some hidden rows and columns.
Using the attached sample spreadsheet ( Download HERE), you will see in the Document Inspector window that a long list. 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.
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.