You can run the Remove Hidden Data add-in on individual files from your Microsoft Office 2002 program or from your Microsoft Office 2003 program. Or, you can run the Remove Hidden Data add-in on multiple files at the same time from the command line. In either case, to run the tool you must have the program installed that you used to create the document.
Note The following dialog box appears in Word and in Excel when you open the files that were saved by using the Remove Hidden Data tool:
If you click Yes, the file will not be editable. If you click No, the file will be editable. This will enable new metadata to be entered.
For more information about the Remove Hidden Data add-in tool and about how to obtain it, visit the following Microsoft Web site:For more information about more known issues and topics that are not covered by the ReadMe file, click the following article numbers to view the articles in the Microsoft Knowledge Base:
- Click Start, and then click Control Panel.
- Click Add or Remove Programs.
- In the list of currently installed programs, click Remove Hidden Data Tool, and then click Click here for support information.
- Use the following table to determine the release version of the Remove Hidden Data tool that you have installed.
Release version Version Remove Hidden Data Tool 1.1 11.0.6361.0 Remove Hidden Data Tool 1.0 6.00.2600.0000
- With your file open, click the Microsoft Office Button, and then point to Prepare.
- Click Inspect Document. The Document Inspector dialog box appears. Notice that all items are selected. This means that all the listed checks will be performed automatically. If you want to skip any items in the list, click to clear the appropriate check boxes.
Microsoft Office 2003 ReadMe File: Remove Hidden Data add-in© 2003 Microsoft Corporation. All rights reserved.
This document provides late-breaking information about the Microsoft Office 2003 Remove Hidden Data add-in. The Contents section lists all of the information contained in this file; for late breaking information specific to an individual Office system product, see the ReadMe file for that product.
Remove Hidden Data is an add-in for Microsoft Office 2003 Editions or Microsoft Office XP that lets users permanently remove hidden data and collaboration data from their Microsoft Word, Microsoft Excel and Microsoft PowerPoint files.
How to use this documentTo view the ReadMe file on the screen, maximize the browser window. To print the ReadMe file, click the Print button on the toolbar.
- System requirements
- Types of data this add-in can remove
- Known issues
- Basic use
- Command line
- Log file
The Remove Hidden Data add-in is a tool that you can use to remove personal or hidden information that might not be immediately apparent when you view the document in the Microsoft Office application.
You can run the Remove Hidden Data add-in on individual files from within the Office XP or Office System 2003 application. Or, you can run Remove Hidden Data on multiple files from the command line. In either case, the application that created the document must be installed in order for you to run the tool.
You should run the Remove Hidden Data add-in on files when you are ready to publish them. This is because some information removed by the tool is used by Office for collaboration features, such as Track Changes, Comments, and Send for Review, and these collaboration features will not work after using the Remove Hidden Data add-in.
The Remove Hidden Data add-in is designed to remove certain types of data from Office files permanently, automatically, and without prompting. By default, the add-in will prompt you to save the file to a new file name.
You should always save using a new file name, rather than overwrite the original file with the new document, in order to preserve a copy of the document containing the original data.
To change the language that the Remove Hidden Data add-in uses, you will need to uninstall the add-in and then download a new copy of the Remove Hidden Data add-in for that language. After the new language add-in has been installed, it will replace the original language version of the add-in. All copies of the Remove Hidden Data add-in, in any language, include an English-language version to support the command-line tool.
This tool cannot remove hidden data from the following types of files:
- Documents using rights-management permissions
- Protected documents
- Digitally signed documents
- Shared workbooks
Return to contents
This download works with the following Office applications:
- Microsoft Office Word 2003
- Microsoft Office Excel 2003
- Microsoft Office PowerPoint 2003
- Microsoft Word 2002, SP2 or later
- Microsoft Excel 2002, SP2 or later
- Microsoft PowerPoint 2002, SP2 or later
Remove Hidden Data works with Word documents, Excel spreadsheets, and PowerPoint presentations, as well as Web pages and single-file Web pages; created by Word, Excel and PowerPoint. It does not work with other document formats.
Return to contents
- Previous authors and editors.
- User name.
- Personal summary information.
- Revision marks. The tool accepts all revisions specified in the document. As a result, the contents of the document will correspond to the Final Showing Markup view on the Reviewing toolbar.
- Deleted text. This data is removed automatically.
- VB Macros. Descriptions and comments are removed from the modules.
- The ID number used to identify your document for the purpose of merging changes back into the original document.
- Routing slips.
- E-mail headers.
- Scenario comments.
- Unique identifiers (Office 97 documents only).
Return to contents
- Excel: In Excel 2002, printer paths are not removed; however, they are removed in Excel 2003.
- Excel: The link to a supporting external workbook may not be cleaned from an Excel single-file Web page.
- If the Remove Hidden Data add-in shuts down unexpectedly, an empty Notepad window may appear and a log file may be left in your temporary directory. To close the Notepad window, press File, Exit in Notepad. To remove this log file, delete the contents of the temporary directory in your local settings folder.
- If you close the Remove Hidden Data add-in before it is finished reviewing a document, one or more temporary files may be left in the destination directory. To remove these files, delete them from the destination directory.
- Single-file Web pages that have been reviewed by this tool may contain the name of a randomly generated temporary file in the form file:///c:/<number>/. The number used in this name is based on the file name of the single-file web page and cannot be traced back to your computer.
- Existing hidden random numbers, used to improve merge accuracy and stored in Word files, are not removed.
- When run from the command line, the Remove Hidden Data add-in does not work on XML documents created in Word, Excel, or PowerPoint.
Note If you do not see the Remove Hidden Data command on the File menu, check the following:
- On the Tools menu, click
Options, and then click the Securitytab.
- Under Macro Security, click Macro Security.
- Click the Trusted Publisherstab.
- Select the Trust all installed add-ins and templates check box, and then click OK twice.
You should always save to a new file name, rather than overwrite the original file with the new document, in order to preserve a copy of the document containing the original data.
The Remove Hidden Data add-in does not support saving documents as templates.
Return to contents
- Quit all instances of Excel, Word, Outlook, and PowerPoint before launching the command-line tool.
- On the Start menu, click
- Type cmd, and then press ENTER.
- Switch to the directory that contains the OFFRHD.EXE file. By default, this is the directory where you installed the Remove Hidden Data add-in.
- At the command prompt, type the syntax for the task you want to perform.
Although your document application is not visible, it is running in the background. If the application launches a dialog box, the Remove Hidden Data add-in will pause until the dialog box is closed. If the dialog box remains open more than 120 seconds, the application will terminate and the Remove Hidden Data add-in will proceed to the next file, or close if it has reached the last file.
You can type either a slash (/) or a dash (-) as a flag to precede parameters. Flags are not case-sensitive.
If you type in multiple flags, only the first one will be recognized.
You must enter the /source parameter first, optionally followed by the /destination parameter. All other parameters can be in any order.
If you type a slash (/) at the end of the source directory name, the tool will fail.
The syntax for OFFRHD.EXE is as follows:
|source||Required. Specifies the drive, directory, and files for which you want to remove personal information. Can be any valid, fully-qualified path name.|
|destination||Optional. Specifies a location for scanned files. If you do not specify this field, all files will be saved in the same directory with a suffix representing the current date. For example, -C010503 would represent January 5, 2003. If the destination file already exists, it will be overwritten.|
|/O||Specifies that no prompt will display to confirm that you want to overwrite an existing file.|
|/R||Specifies that contents of the source directory and its subdirectories will be examined.|
|/F:filetype||Specify format for destination files.|
|/F:B||Specifies binary document format. If you do not specify this parameter, the default will be to save in the same format as the source file.|
|/L:logfile||Specifies a location to stores the log file. If you do not specify this, the log will display when the tool is finished.|
|/A||Specifies that the tool will generate a report of issues found in the file but will not remove any data.|
|/:?||Displays a list of all available parameters.|
Return to contents
Article ID: 834427 - Last Review: Sep 22, 2009 - Revision: 1