You are here LEARN EXCEL & VBA Excel Tips Excel General Removing Personal Information from a Workbook

Removing Personal Information from a Workbook

Why is it important to remove personal information from a workbook?

*When you do not want to expose your personal details when posting a question with an attached
*sample workbook to a Web forum.
*When sending a workbook by mail.
*When publishing a workbook on a Web site that allows downloading.

To remove personal information from a workbook:

1. From the Files menu, select Properties, and then select the Summary tab.
2. Remove personal information and click OK.
To remove personal information from a workbook in Excel versions 2002 and 2003:
3. From the Tools menu, select Options, and then select the Security tab.
4. Check Remove personal information from file properties on save and then click OK.

Screenshot // Removing Personal Information from a Workbook
Removing Personal Information from a Workbook