Wednesday, April 07, 2010

Excel Quick Tips: Disable Privacy Warning

If each time when you save your macro enable workbook, you receive an annoying popup "Privacy warning:This document contains macros, ActiveX controls, XLM expansion pack information, or web components. These may include personal information that cannot be removed by the Document Inspector", follow these steps

1.  Go to Excel Options, navigate to Trust Center and click on “Trust Center Settings”

2. First, enable all macros in the Macro Settings (Note: Assuming all your macros are safe and tested)

Enable-Macro

3. Then go to Privacy Options and uncheck “Remove personal information…”

DocInspector

4. Save and close the file. Next time when you open it, no more annoying privacy warnings.

7 comments:

Anonymous said...

Brilliant!!!

Anonymous said...

It worked... Thanks allot

Anonymous said...

Thanks, it worked great. Sooooo tired of the pointless, annoying and moronic prompts from Microsoft. WHO CARES?

Sam said...

Thanks for sharing that tip. It's great to know how to disable privacy warning in Excel.

web design Perth

Anonymous said...

thanks, really useful :)

THE SEO PORTAL said...

I'm impressed. You're truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. I'm saving this for future use.

Anonymous said...

Step 2 ("enable all macros in the Macro Settings") is not necessary.

In fact, step 2 is - by the looks of it - quite dangerous.

You only need to uncheck 'Remove Personal Information' under Privacy Settings to disable the warning.