How To Remove Personal Information From A Workbook In Microsoft Excel 2010

 

If you are sharing your workbook with others then you should review the workbook for personal information or hidden data that may be stored & later on reveal the important information like company name, author, etc. As this information is more than sufficient for other person to figure out the kind of work is going on, in short to secure the data to be shared publicly, you may want to remove the hidden information each time you share the workbook with other person.

If your workbook is saved as a shared workbook you cannot remove comments, annotations, document properties and personal information. To get rid of this information from a shared workbook, unshared the workbook.

In this article we will let you understand how the Document Inspector feature in Excel can help you in removing hidden data and personal information in your workbooks.

To prevent this information from a workbook being shared publicly with other people you can follow the below steps:

  • Click on File ribbon
  • Select Info
  • Click on Check for Issues & select Inspect Document

 
img1
 

  • The Document Inspector window will appear on the screen
  • Click on Inspect button

 
img2
 

  • Click on Remove All

 
img3
 

  • You can review the Document Inspector result is as follows:

 
img4
 

  • Click on Close

The next time you will open the workbook you will not find personal information.
 
 



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>