When you save Excel files, some personal information can be stored in the file properties, or in the content of the file itself. If someone else will be opening a file that you create, you may or may not want them to see the Author, Manager, Company, or last saved by information that is available in the file properties. There can also be personal names stored in the Excel file, in the form of comments inserted by co workers who reviewed a shared workbook.

 

To remove this kind of personal information from a workbook before distributing copies of it, choose Tools->Options from the menu bar to display the Options dialogue box.

 

 

Next, select the Security tab and put a checkmark in the checkbox labelled Remove personal information from file properties on save. When you save the file, the author, company, manager, and last saved by information will be removed from the properties. In addition, names associated with comments in a shared workbook are replaced with the word Author.