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.
  • 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
  • Click Inspect after selecting (or deselecting) any pertinent content simply click the Inspect button. If issues are located, the dialog will prompt you.
  • You can rerun after opting to remove content and saving.
  • 0 comments to “Excel 2007 Remove Document Data”

    Post a Comment

     

    Computer Info Copyright © 2016 -- Powered by Blogger