CertCities.com -- The Ultimate Site for Certified IT Professionals
Post Your Mind in the CertCities.com Forums Share share | bookmark | e-mail
  Microsoft®
  Cisco®
  Security
  Oracle®
  A+/Network+"
  Linux/Unix
  More Certs
  Newsletters
  Salary Surveys
  Forums
  News
  Exam Reviews
  Tips
  Columns
  Features
  PopQuiz
  RSS Feeds
  Press Releases
  Contributors
  About Us
  Search
 

Advanced Search
  Free Newsletter
  Sign-up for the #1 Weekly IT
Certification News
and Advice.
Subscribe to CertCities.com Free Weekly E-mail Newsletter
CertCities.com

See What's New on
Redmondmag.com!

Cover Story: IE8: Behind the 8 Ball

Tech-Ed: Let's (Third) Party!

A Secure Leap into the Cloud

Windows Mobile's New Moves

SQL Speed Secrets


CertCities.com
Let us know what you
think! E-mail us at:



 
 
...Home ... Editorial ... Columns ..Column Story Saturday: April 5, 2014


 Tip o'the Week  
Zubair Alexander
Zubair Alexander


 Removing Hidden Data in Office 2007 Docs
How can I remove the personal information displayed in the Properties of Microsoft Office 2007 documents?
by Zubair Alexander  
8/5/2009 -- There are some pieces of information, such as an author's name and company, that can be manually deleted by going to the Office icon, clicking Prepare and then Properties. However, if you're working with several documents, this might be a tedious process.

Not to mention the fact that some information displayed on the Statistics tab, such as the last user who saved the document, can't be deleted manually. In addition, there's hidden data in each document that just cannot be manually deleted.

For Office 2003/XP, Microsoft offered an add-in called Remove Hidden Data to accomplish this task. In Office 2007, Microsoft introduced the Document Inspector, a feature which takes care of removing hidden metadata from an Office 2007 document.

Document Inspector
[Click on image for larger view.]

To access this feature in an Office 2007 application, click on the Office icon, Prepare, and then click Inspect Document. You'll have the option to select or deselect various options for inspection, such as Document Properties and Personal Information, and Hidden Text. Once the inspection is complete, you'll have the option to remove the items you want.

In Excel 2007, there are seven items that can be inspected and removed, including Hidden Worksheets, Hidden Rows and Columns, and Invisible Content. Other applications in Office 2007 offer different options.

One thing to keep in mind: Make sure that you save the original version of the document before you save a version that has the hidden data removed, in case you need to display that data for certain users or for yourself.


Zubair Alexander, MCSE, MCT, MCSA and Microsoft MVP is the founder of SeattlePro Enterprises, an IT training and consulting business. His experience covers a wide range of spectrum: trainer, consultant, systems administrator, security architect, network engineer, author, technical editor, college instructor and public speaker. Zubair holds more than 25 technical certifications and Bachelor of Science degrees in Aeronautics & Astronautics Engineering, Mathematics and Computer Information Systems. His Web site, www.techgalaxy.net, is dedicated to technical resources for IT professionals. Zubair may be reached at .

 


More articles by Zubair Alexander:

-- advertisement --


There are 4 CertCities.com user Comments for “Removing Hidden Data in Office 2007 Docs”
Page 1 of 1
10/17/09: Raul from Italy says: http://community.teensforlife.com/service/displayKickPlace.kickAction?u=13277459&as=99668
10/20/09: OdoriePreoppY from Burma says: Hi there, my home page is http://www.google.com
10/30/09: Pharme830 from USA says: Very nice site!
11/6/09: Pharmd487 from USA says: Very nice site!
Your comment about: “Removing Hidden Data in Office 2007 Docs”
Name: (optional)
Location: (optional)
E-mail Address: (optional)
Comment:
   

-- advertisement (story continued below) --

top