Cart 0

Removing Personal Information from Workbooks

Posted by Roger Hyttinen on

As you make changes to your workbooks, Excel records a variety of personal and hidden data. This can include the document author, comments and revision marks, document server properties, document metadata and other sensitive information about your company that you may not wish to share publicly. Thus, you might want to remove this hidden information before sharing your workbook with others.

Document Inspector window

The Document Inspector can remove hidden data and personal information from your Excel file. Note however, that once your remove this information, you may not be able to retrieve it so you should make a backup copy of your original workbook. You will also need to remove Shared access before running the Document Inspector.

To Inspect a Workbook

  1. Click the File tab and click Info.
  2. In the center pane, click the Check for Issues button and then click Inspect Document.
    Info window in Backstage view
  3. Select the check boxes next to the types of information you want to be inspected.
  4. Click the Inspect button.
  5. Click the Remove All button next to the types of information you want removed from your document.
Remove All button

      Looking for more Excel tips? Check out our new book Excel 2016:Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks

      Share this post

      ← Older Post Newer Post →