Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →An Excel workbook can contain information that is not visible in the sheet you are looking at: hidden sheets or rows, document properties, comments, and links to other files are among the things it may retain. Excel’s Document Inspector can find and remove some of these items, but it does not clean everything. Inspect a copy, review each finding before removing it, then inspect the cleaned copy again.
What can an Excel workbook reveal?
A workbook’s visible cells are only part of what may be shared. Depending on how the file was created and used, it can also include:
- Personal and document information: properties such as author, title, subject, who last saved the file, its creation date, or its document location.
- Content outside the current view: comments and ink annotations, headers and footers, hidden rows, columns, or worksheets, and invisible content.
- Connections and workbook features: external workbook links, embedded files or objects, macros or VBA, cached PivotTable or PivotChart data, slicer or timeline data, cube-formula data, Excel Survey questions, scenarios, filter caches, and hidden names.
Not every workbook contains these items. Some information depends on the features used or the file’s history. Microsoft’s Excel privacy guidance also describes feature-dependent details such as file paths, external data, and authorization information in certain cases.
How to inspect a copy in desktop Excel
Microsoft recommends using a copy because removing findings may not be reversible. Keep the original as a recovery point, and do not treat inspection as proof that the workbook contains no sensitive information.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →- Make a separate copy. Save a new copy of the workbook and open that copy in Excel.
- Open Document Inspector. Select File > Info > Check for Issues > Inspect Document.
- Choose what to check. Select the categories relevant to the workbook, then run the inspection.
- Review each result. Read what Excel found before choosing to remove anything. Hidden content may support formulas or calculations.
- Remove only what should not be shared. Use the removal option for appropriate findings; investigate items that Excel only identifies or that could affect the workbook’s behavior.
- Inspect again. Re-run Document Inspector on the cleaned copy, then check that its remaining contents are intended before sharing.
Microsoft Support cautions: “We highly recommend that you use the Document Inspector on a copy of your original workbook, because it is not always possible to restore the data that the Document Inspector removes.”
What the Inspector can remove—and what needs separate attention
Findings do not all work the same way. The Inspector can remove some categories, but for other findings it may only report the issue, or removal may not be safe because it could affect workbook functionality.
Rank #2
| Finding | What to do |
|---|---|
| Comments and annotations, document properties and personal information, headers and footers, hidden rows, columns or worksheets, custom XML, and some invisible content | Review the finding and use the Inspector’s removal option when the information should not be included. Check formulas and calculations before removing hidden sheet content. |
| External workbook links | The Inspector can find these links but cannot remove them. Review the links; delete those that should go, or break them if you want to retain their calculated values. See Microsoft’s external links guidance, then inspect again. |
| Embedded files or objects, macros or VBA, cached business-intelligence data, Survey questions, scenarios, filter caches, and hidden names | Inspect these manually. Decide whether each item belongs in the shared file; preserve features the recipient needs. |
Excel may not detect objects covered by other objects. The precise findings and available removal actions can vary with the content and features in a workbook, so a clean inspection result is not a guarantee that nothing sensitive remains.
Why hidden sheets and protection are not enough
Hiding a worksheet changes what is shown in the workbook; it does not remove the sheet’s data. Workbook structure protection can restrict access to hidden sheets and prevent structural changes, but it is not a substitute for removing information you do not want to distribute. Microsoft explains these controls in its workbook protection guidance.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Repair Windows errors before they cause bigger problems3Scan for outdated or missing drivers - takes under a minuteSimilarly, settings for blocking or allowing external content control whether certain linked content or connections can update. They do not remove existing metadata or hidden workbook content. Treat that as a separate question from what the file contains, and consult Microsoft’s external content guidance if updates are the concern.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.If the workbook uses legacy Shared Workbook mode
Microsoft notes a special limitation for the legacy Shared Workbook feature: inspectors for comments and annotations, properties and personal information, and headers and footers cannot be used in that mode. Its guidance describes making a copy and turning off the legacy feature to remove that information. Because the exact steps depend on the Excel version and workbook setup, check the instructions for your version before changing the sharing mode.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
