Microsoft KB Archive/284880

= Personal data is not removed as expected when Excel file is saved =

Article ID: 284880

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q284880





SYMPTOMS
When a Microsoft Office Excel 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 Excel does not remove personal information from a shared workbook.



RESOLUTION
To remove the personal information from a shared workbook, follow these steps:

Excel 2007

 * 1) Open the document that contains the personal information.
 * 2) On the Review tab, click Share Workbook in the Changes group.
 * 3) On the Editing tab, click to clear the Allow changes by more than one user at the same time. This also allows workbook merging. check box, and then click OK.
 * 4) Click the Microsoft Office Button, and then click Excel Options.
 * 5) Click Trust Center, and then click Trust Center Settings.
 * 6) In the Trust Center dialog box, click Privacy Options, and then click to select the Remove personal information from file properties on save check box.
 * 7) Click the Microsoft Office Button, and then click Save.
 * 8) On the Review tab, click Share Workbook in the Changes group.
 * 9) On the Editing tab, click to select the Allow changes by more than one user at the same time. This also allows workbook merging. check box, and then click OK.

Excel 2003, Excel 2002, and Excel 2000

 * 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 in the &quot;Applies to&quot; section.

Additional query words: XL2002 XL2003 XL2007

Keywords: kbbug kbpending KB284880

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.