How can I remove hidden information from Microsoft Word, Excel, and PowerPoint documents?
Microsoft Word, Excel, and PowerPoint documents contain a variety of hidden information, including names, email addresses, deleted text, revision marking, and locations of related files on your computer. While some of the data is needed by collaboration features such as Track Changes, Comments, and Send for Review, other information you may not intend to share may be viewable by anyone with access to the document.
On this page:
- Office settings controlling hidden data
- Document Inspector in Office 2010 and 2007
- Removing hidden data in previous versions of Office
- Removing hidden data that cannot be removed by any Office setting
Office settings controlling hidden data
Whether these types of data are stored in your document depends largely (but not entirely) on settings in your Office applications. Office applications can keep track of revisions made by everyone who modifies a document.
Office applications keep track of these revisions with the Track
Changes feature. To enable this, from the Review tab (2010)
or the Tools menu (2007 and 2003), select Track
Changes. As the file is modified, any changed or deleted text is
automatically added to the file, along with the name of the user who
made the edit. To view the tracked changes, from the Review
tab (2010) or View menu (2007 and 2003), select
Markup.
Document Inspector in Office 2010 and 2007
Word, Excel, and PowerPoint 2010 and 2007 use the Document Inspector tool to search for and remove both personal data and tracked changes to a document. To use the Document Inspector:
- Open an Office document to inspect for hidden data or
personal information.
- From the
Filetab (2010) or the Office Button menu (2007), selectSave As. To save a copy of your original document, enter a name in the "File name" field.Note: It's a good idea to use the Document Inspector on a copy of your original document, because it's not always possible to restore the data that the Document Inspector removes.
- In your original document, in 2010, from the
Filetab, clickInfo, thenCheck for Issues, and thenInspect Document. In 2007, from the Office Button menu, selectPrepare, and then clickInspect Document.
- In the
Document Inspectordialog box, check the boxes to choose the types of hidden content that you want to inspect. For more about the individual Inspectors, see Remove hidden data and personal information from Office documents.
- Click
Inspect. Review the results of the inspection in theDocument Inspectordialog box. ClickRemove Allnext to the inspection results for the types of hidden content that you want to remove from your document.Note: If you remove hidden content from your document, you might not be able to restore it by clicking
Undo.
Removing hidden data in previous versions of Office
Note: This option is only available if you edit a document in Office 2007 which was originally created using Track Changes in a previous version of Office.
- Open the document containing the hidden data you wish to remove.
- From the
Toolsmenu, selectOptions.
- Select the
Securitytab in the window that appears.
- Check
Remove personal information from this file on save.
Removing hidden data that cannot be removed by any Office setting
To remove hidden data that cannot be removed by any Office setting, use one of the following tools:
Microsoft Remove Hidden Data add-in for Office 2003
Microsoft's Remove Hidden Data add-in is a command-line utility and macro available at the Microsoft Download Center. This tool will automatically remove all of the hidden reviewing data and personal information, along with many other types of hidden data. Instructions on installing and using this add-in from within Office applications are available at the site. This tool will work with Word, Excel, and PowerPoint. This tool is only supported in Windows XP.
Additional add-ins
For Microsoft Outlook, you can download add-ins that ensure that all Office documents sent as email attachments are cleansed of potentially sensitive information:
Acknowledgment
Significant portions of this document were adapted from the article "Revealing Codes" by David A. Karp, which appeared in PC Magazine, June 8, 2004.
Last modified on August 09, 2010.







