Monday, March 7, 2016

Excel 2007 Remove Document Data

While getting ready to send some data to a customer I wanted to be sure any comments or personal data was fully removed.  I was sure Office had a way to pull this office, but, was not quite sure of what it was.  So, I Googled this:
Remove hidden data and personal information from Office documents
In the end it proved to be pretty simple:

  1. Select File > Prepare > Inspect Document.
  2. If the file has been modified since the last time it was saved you will be prompted to save the document before running the Inspection.
  3. After the file has been saved, you will be prompted to check for seven different types of content:
    1. Comments and Annotations
    2. Document Properties and Personal Information
    3. Custom XML Data
    4. Headers and Footers
    5. Hidden Rows and Columns
    6. Hidden Worksheets
    7. Invisible Content
  4. Click Inspect after selecting (or deselecting) any pertinent content simply click the Inspect button. If issues are located, the dialog will prompt you.
  5. You can rerun after opting to remove content and saving.

Related Post:

0 comments:

Post a Comment

 
Copyright 2009 Information Blog
Powered By Blogger