XL2002: Personal Data Is Not Removed as Expected When File Is Saved (284880)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q284880

SYMPTOMS

When a workbook is saved and the Remove personal information from this file on save check box is selected, personal information such as your name and company name may not be removed from the file properties as expected.

CAUSE

This behavior can occur if the workbook is shared because Microsoft Excel does not remove personal information from a shared workbook.

RESOLUTION

To remove the personal information from a shared workbook, follow these steps:
  1. Open the document.
  2. On the Tools menu, click Share Workbook.
  3. Click to clear the Allow changes by more than one user at the same time check box, and then click OK.
  4. On the Tools menu, click Options.
  5. On the Security tab, click to select the Remove personal information from this file on save check box, and then click OK.
  6. On the File menu, click Save.
  7. On the Tools menu, click Share Workbook.
  8. Click to select the Allow changes by more than one user at the same time check box, and then click OK.
Note that the personal information is removed.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

For more information about the limitations of shared workbooks, click Microsoft Excel Help on the Help menu, type shared workbooks in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:3/27/2001
Keywords:kbbug KB284880
©2002 Microsoft Corporation. All rights reserved.