Inspect workbooks for hidden data and personal information

If you plan to share an electronic copy of a Microsoft Office Excel workbook, it is a good idea to review the workbook for hidden data or personal information that might be stored in the workbook itself or its document properties (metadata (metadata: Data that describes other data. For example, the words in a document are data; the word count is an example of metadata.)). Because this hidden information can reveal details about your organization or about the workbook itself that you might not want to share publicly, you might want to remove this hidden information before you share the workbook with other people.

This article explains how the Document Inspector feature in Microsoft Office Excel 2007 can help you find and remove hidden data and personal information in your Excel workbooks.

 Note   You can remove hidden data and personal information from workbooks that you share with other people. However, if your workbook has been saved as a shared workbook (Review tab, Share Workbook command), you cannot remove comments, annotations, document properties, and personal information. To remove this information from a shared workbook, first copy and unshare the workbook.

In this article


What types of hidden data and personal information are stored in workbooks?

Several types of hidden data and personal information can be saved in an Excel workbook. This information might not be immediately visible when you view the workbook in Office Excel 2007, but it might be possible for other people to view or retrieve the information.

Hidden information can include the data that Office Excel 2007 adds to a workbook to enable you to collaborate on it with other people. It can also include information that you deliberately designate as hidden.

Excel workbooks can contain the following types of hidden data and personal information:

  • Comments and ink annotations    If you collaborated with other people to create your workbook, your workbook might contain items such as comments or ink annotations. This information can enable other people to see the names of people who worked on your workbook, comments from reviewers, and changes that were made to your workbook.
  • Document properties and personal information    Document properties, also known as metadata (metadata: Data that describes other data. For example, the words in a document are data; the word count is an example of metadata.), include details about your workbook such as author, subject, and title. Document properties also include information that is automatically maintained by Office programs, such as the name of the person who most recently saved a workbook and the date when a document was created. If you used specific features, your document might also contain additional kinds of personally identifiable information (PII) (personally identifiable information (PII): Any information that can be used to identify a person, such as a name, address, e-mail address, government ID, IP address, or any unique identifier associated with PII in another program.), such as e-mail headers, send-for-review information, routing slips, printer paths, and file path information for publishing Web pages.
  • Headers and footers    Excel workbooks can contain information in headers and footers.
  • Hidden rows, columns, and worksheets    In an Excel workbook, rows, columns, and entire worksheets can be hidden. If you distribute a copy of a workbook that contains hidden rows, columns, or worksheets, other people might unhide these row, columns, or worksheets and view the data that they contain.
  • Document server properties    If your workbook was saved to a location on a document management server, such as a Document Workspace site or a library based on Microsoft Windows SharePoint Services, the workbook might contain additional document properties or information related to this server location.
  • Custom XML data    Workbooks can contain custom XML data that is not visible in the document itself. The Document Inspector can find and remove this XML data.
  • Invisible content    A workbook can contain objects that are not visible because they are formatted as invisible.

Top of Page Top of Page

What information can the Document Inspector find and remove from workbooks?

In Office Excel 2007, the Document Inspector displays several different Inspectors that enable you to find and remove hidden data and personal information that is specific to Excel workbooks. For a list of the different types of hidden data and personal information that the Document Inspector can find and remove from Excel workbooks, review the following table.

 Note   If your organization customized the Document Inspector by adding Inspector modules, you might be able to check your workbooks for additional types of information.

Office Excel 2007

Inspector name Finds and removes
Comments and Annotations
  • Comments
  • Ink annotations
Document Properties and Personal Information
  • Document properties, including information from the Summary, Statistics, and Custom tabs of the Document Properties dialog box
  • E-mail headers
  • Routing slips
  • Send-for-review information
  • Document server properties
  • Document Management Policy information
  • Content type information
  • User name
  • Printer path information
  • Scenario comments
  • File path for publishing Web pages
  • Comments for defined names and table names
  • Inactive external data connections
Headers and Footers
  • Information in worksheet headers
  • Information in worksheet footers
Hidden Rows and Columns
  • Hidden rows
  • Hidden columns that contain data

 Notes 

  • If there are hidden columns in your workbook that do not contain data and they are located between columns that do contain data, these empty hidden columns will also be detected and removed.
  • If the hidden rows or columns in your workbook contain data, you might change the results of the calculations or formulas in your workbook by removing them. If you do not know what information the hidden rows or columns contain, close the Document Inspector, unhide the hidden rows or columns, and then review their contents.
  • This Inspector does not detect shapes, charts, controls, Microsoft ActiveX objects and controls, pictures, or SmartArt graphics that might be located in hidden columns.
Hidden Worksheets
  • Hidden worksheets

 Note   If the hidden worksheets in your workbook contain data, you might change the results of the calculations or formulas in your workbook by removing them. If you do not know what information the hidden worksheets contain, close the Document Inspector, unhide the hidden worksheets, and then review their contents.

Custom XML Data
  • Custom XML data that might be stored within a workbook
Invisible Content
  • Objects that are not visible because they are formatted as invisible

 Note   This Inspector does not detect objects that are covered by other objects.

Top of Page Top of Page

How do I find and remove hidden data and personal information in my workbooks?

You can use the Document Inspector to find and remove hidden data and personal information in Excel workbooks that were created in Office Excel 2007 and earlier versions. It is a good idea to use the Document Inspector before you share an electronic copy of your workbook, such as in an e-mail attachment.

  1. Open the workbook that you want to inspect for hidden data and personal information.
  2. Click the Microsoft Office ButtonButton image, click Save As, and then type a name in the File name box to save a copy of your original workbook.

 Important   It is a good idea to use the Document Inspector on a copy of your original workbook because it is not always possible to restore the data that the Document Inspector removes.

  1. In the copy of your original workbook, click the Microsoft Office ButtonButton image, point to Prepare, and then click Inspect Document.
  2. In the Document Inspector dialog box, select the check boxes to choose the types of hidden content that you want to be inspected. For more information about the individual Inspectors, see What information can the Document Inspector find and remove from workbooks?
  3. Click Inspect.
  4. Review the results of the inspection in the Document Inspector dialog box.
  5. Click Remove All next to the inspection results for the types of hidden content that you want to remove from your document.

 Important   

  • If you remove hidden content from your document, you might not be able to restore it by clicking Undo.
  • If you remove hidden rows, columns, or worksheets that contain data, you might change the results of the calculations or formulas in your workbook. If you do not know what information the hidden rows, columns or worksheets contain, close the Document Inspector, unhide the hidden rows, columns, or worksheets, and then review their contents.
  • The inspectors for Comments and Annotations, Document Properties and Personal Information, and Headers and Footers cannot be used in a workbook that has been saved as a shared workbook (Review tab, Shared Workbook command). This is because shared workbooks use personal information to enable different persons to collaborate on the same workbook. To remove this information from a shared workbook, you can copy the workbook and then unshare it. To unshare a workbook, on the Review tab, click Shared Workbook. On the Editing tab, clear the Allow changes by more than one user at the same time check box.
  • If you want to remove hidden data and personal information from spreadsheets you save in the OpenDocument Spreadsheet (.ods) format, you must run the Document Inspector every time you save the spreadsheet in this format.

Top of Page Top of Page

 
 
Applies to:
Excel 2007