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:

1. Open the Office document you wish to inspect for hidden data or personal information.
   
   
2. 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.

3. In the copy of your original document, from the Office Button menu, select Prepare, and then click Inspect Document.
   
   
4. In the Document Inspector dialog 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.
   
   
5. Click Inspect. Review the results of the inspection in the Document Inspector dialog box. Click Remove All next 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.

1. Open the document containing the hidden data you wish to remove.
   
   
2. From the Tools menu, select Options.
   
   
3. Select the Security tab in the window that appears.
   
   
4. 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:

Also, you can download Workshare Protect at:

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.