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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube