Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to remove personal information of a workbook?

When you create and save a workbook, some of your personal information such as Author name, Last saved by are saved as File properties. You may want to remove this information if you need to share your workbook with others. But, in Excel, how could you remove the personal information of a workbook quickly and easily?

Remove personal information of a workbook with Inspect Document feature

Remove personal information of a workbook with VBA code

Enable you to do smarter, faster and better

Kutools - the best office productivity tool brings 300 advanced features to Excel. Details... Download...

Office Tab - brings tabbed interface to Excel and Word, make your work much easier. Details...Download...


arrow blue right bubble Remove personal information of a workbook with Inspect Document feature


In Excel, you can apply the Inspect Document feature to inspect the personal information of a workbook, and then remove them as you need.

1. Launch your workbook, and click File > Info > Check for Issues > Inspect Document in Excel 2010/2013, see screenshot:

doc-remove-personal-information-1

Tip: In Excel 2007, please click Office Button > Prepare > Inspect Document, see screenshot:

doc-remove-personal-information-1

2. In the Document Inspector dialog box, please click Inspect button at the bottom of the dialog to check up the personal information, when the Document Properties and Personal Information is displayed, click Remove All. See screenshot:

doc-remove-personal-information-1

3. Then close the dialog, and the personal information has been removed from the workbook.


arrow blue right bubble Remove personal information of a workbook with VBA code

Here also is a simple code can help you to remove the personal information.

1. Open your workbook that you want to remove the personal information.

2. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.

3. Click Insert > Module, and paste the following code in the Module Window.

VBA code: remove personal information of a workbook

Sub remove()
    ActiveWorkbook.RemovePersonalInformation = True
End Sub

4. Then press F5 key to run this code, and then save and close your workbook. When you open your workbook next time, the personal information has been removed.



Excel Productivity Tools

Kutools for Excel - The Best Office Productivity Tool

  • Brings 300 powerful advanced features to Excel, enable you to do smarter, faster and better.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Office Tab - brings tabbed interface to Office, make your work much easier.

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.