Jump to content

Delete personal information from a worksheet


Recommended Posts

Delete personal information from a worksheet

If you regularly e-mail your spreadsheets to users or copy them to a shared server, you can use Excel 2002's Options menu to delete any personal information from them before others can see it.

To delete personal information, follow these steps:

1. Unshare the workbook if you have previously shared it.

2. Go to Tools | Options.

3. On the Security tab, select the Remove Personal Information From This File On Save check box, and click OK.

After you save the workbook, Excel will delete the following information from the file:

• File properties (e.g., author, manager, company, etc.)

• Routing slips

• E-mail message header

• Paths associated with downloaded components and smart tags

• Personal views

• Name of the last person to open the workbook

In addition, Excel changes names associated with PivotTable reports, comments, and scenarios to Author. However, this will not remove personal information contained in macros.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...