How can I remove hidden information from Microsoft Word, Excel, and PowerPoint documents?
On this page:
- Introduction
- Office settings controlling hidden data
- Document Inspector in Office 2007
- Removing hidden data that cannot be removed by any Office setting
Introduction
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.
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 Tools menu, 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
View menu, select Markup.
Document Inspector in Office 2007
Note: The interface for Office 2007 programs is significantly different from that of older versions, with different terms and concepts; see For Office 2007, what are some new interface features?
Word, Excel, and PowerPoint 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 the Office document you wish to inspect for hidden data or
personal information.
- From the Office Button menu, select
Save 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 the copy of your original document, from the Office Button
menu, select
Prepare, and then clickInspect Document.
- In the
Document Inspectordialog box, select the checkboxes to choose the types of hidden content that you want to inspect. For more information about the individual Inspectors, see Remove hidden data and personal information from Office documents at the Microsoft Office Online web site.
- 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 using Office 2007
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
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 Office XP and 2003, with Word, Excel, and PowerPoint. This tool is only supported in Windows XP, but may also work in Windows 2000.
Office 2000 HTML Filter 2.0
If you create web pages with Office, you may want to install the Office 2000 HTML Filter 2.0, which is available for download at the Microsoft Download Center. This tool will remove nearly all hidden data from your Office-generated HTML pages. It will also purge the extraneous HTML tags, thus reducing the file size and download time by as much as 50%.
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. iScrub is available from Esquire Innovations at:
http://www.esqinc.com/Also, you can download Workshare Protect at:
http://www.workshare.com/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 May 13, 2009.






