When you share an Excel file, you might accidentally send hidden data you did not intend to include. This information can be stored in file properties, comments, or document metadata. The Document Inspector is a built-in tool that finds and removes this hidden content. This article shows you how to use it to clean your files before distribution.
Key Takeaways: Cleaning Excel Files for Sharing
- File > Info > Check for Issues > Inspect Document: Runs the Document Inspector to scan for hidden data like author names and comments.
- Remove All button in the Document Inspector: Permanently deletes the selected type of hidden information from your workbook.
- File > Info > Properties > Show All Properties: Manually view and edit metadata such as the author, title, and last saved by details.
What the Document Inspector Finds and Removes
Excel files contain more than just the data in cells. Information like your name, file paths, previous edits, and hidden rows can be embedded. This happens automatically as you work. The Document Inspector checks for several specific types of this hidden content.
Common Types of Hidden Information
Document properties and personal information include the author name, company, and the “Last saved by” user. Comments and notes are visible in the sheet but can be overlooked. Hidden rows, columns, and worksheets contain data not immediately seen. Invisible objects like shapes or images with white fill can hide information.
Custom XML data and headers/footers might also store details. External data connections and links to other files can reveal network paths or server names. The inspector gives you control over what to remove.
Steps to Inspect and Clean Your Excel File
Always save a copy of your original workbook before using the Document Inspector. The removal actions are permanent for the file you are inspecting.
- Open the workbook you want to clean
Launch Excel and open the file you plan to share. - Go to File > Info
Click the File tab on the ribbon to go to the Backstage view. Select Info from the left-hand menu. - Click Check for Issues and select Inspect Document
In the Info panel, click the “Check for Issues” button. Choose “Inspect Document” from the dropdown menu. A dialog box will appear. - Select the inspection modules
The Document Inspector dialog lists checkboxes for different content types. Ensure all relevant boxes are checked. Click the Inspect button to start the scan. - Review the inspection results
After scanning, the inspector shows results. Each section has a brief description and a Remove All button if content was found. - Remove the hidden information
Click Remove All next to each content type you want to delete. For example, click Remove All in the “Document Properties and Personal Information” section. - Save the cleaned workbook
Close the inspector dialog. Use File > Save As to save the cleaned file with a new name, clearly marking it as the version for sharing.
Common Mistakes and Things to Avoid
Forgetting to Check for Hidden Worksheets
The Document Inspector checks the active worksheet by default. If your workbook has multiple sheets, right-click any sheet tab and select “Select All Sheets” before running the inspector. This ensures all worksheets are included in the scan.
Removing Data You Need to Keep
Be careful when removing hidden rows, columns, and worksheets. The inspector cannot recover this data after you click Remove All. It is best to manually review hidden content first. Unhide rows and columns via the Home > Format menu to see what they contain.
Overlooking External Links and Connections
If your file has queries or links to other workbooks, removing them will break the data connection. Decide if you need to share a static copy instead. Use Data > Queries & Connections to review and edit links before inspection.
Manual Review vs. Document Inspector
| Item | Manual Review | Document Inspector |
|---|---|---|
| Best for | Checking specific cells, formulas, and visible objects | Finding embedded metadata and invisible content |
| Speed | Time-consuming and easy to miss details | Fast, automated scan of the entire file |
| Control | Full control over each piece of data | Bulk removal by category |
| Risk of data loss | Low, as you see each action | High if you remove content without checking |
| Coverage | Does not find document properties or custom XML data | Finds all hidden information types systematically |
Use the Document Inspector as your primary cleaning tool. Always save the cleaned file with a new name. For advanced control, manually edit file properties via File > Info > Properties before running the inspector. This two-step process gives you the cleanest, safest file for sharing.