Privacy warning: This document contains macros, ActiveX controls…

Recently I have tried to create a macro for my Excel 2007 workbook. The macro did not work properly, then I found a better way with use of Excel functions and I deleted the macro. However, since then I started receiving the following error message every time I want to save my workbook

The fix has been found pretty quickly but is not easy to memorize, so I have posted it  here.

  • Click on Excel Office Button
  • Click on the Excel Options button
  • Select the Trust Center tab
  • Click on the Trust Center Settings… button
  • Select the Privacy Options tab
  • Uncheck the Remove personal information from file properties on save box
  • Click OK twice

57 Responses to Privacy warning: This document contains macros, ActiveX controls…

  1. Anonymous says:

    Thanks it was really helpfull for me..


  2. Anonymous says:

    It worked 🙂


  3. Anonymous says:

    Thanks I looked for it a long time 🙂


  4. Anonymous says:

    Thank you, Great

  5. Anonymous says:

    But permanently how to solve

  6. Anonymous says:

    Thanks. It was of tremendous help.


  7. Akhtar says:

    Great job. Thanks.

  8. hash says:

    Thanks. Been bothered with this same issue for many days until I stumbled upon your site. Many thanks.

  9. Sajid Mukhtar says:


    Thanks bro

  10. Anonymous says:

    çok teşekkür ederim. çok uzun zamandır arıyordum. sonunda buldum. (Thank you very much. looking for a very long time. I have found it.)

  11. moshi says:


    […]Privacy warning: This document contains macros, ActiveX controls… « Notes of Windows Admin[…]…

  12. Anonymous says:

    thanks nice work

  13. Anonymous says:

    thanks.. works

  14. Anonymous says:

    Great! It works easy and quick!

  15. Anonymous says:

    we face the same prob. now we happy to remove it

  16. Sai babu says:


  17. rizki says:

    thanks it really works. ^_^

  18. Anonymous says:

    excellent, been looking for this all week.

  19. Anonymous says:

    great… i can save my file without the annoying privacy thing… thanks a lot… A’s for you my friend.

  20. Anonymous says:

    Many thanks! I was running crazy about this one!!!!

  21. Anonymous says:

    Thanks, this was exactly what I needed to know.

  22. Anonymous says:

    Billion Thanks 🙂

  23. It’s worth noting that this disables a security feature in Excel. It might be better to find out what is wrong with the workbook that you’re working in rather than disabling this option.

    • rufff says:

      This is an important point, and you are 100% accurate, however 90% of ‘solutions’ to this issue simply turn off the warnings. Why can’t excel show you exactly where the issue is instead of just show a generic warning sign? You really want to solve the issue not just cover it up but they don’t make this easy.

  24. brajeshmerta says:

    it helped thanks

  25. Kishor says:

    Thanks my Friend…. Its very useful for me……….

  26. Anonymous says:

    It worked, thanks

  27. Anonymous says:

    thanks, it works…

  28. YS says:

    Great !!!!!

  29. sandip says:

    Thaks it works !!!

  30. Anonymous says:

    Many thanks! Proved most helpful!

  31. Anonymous says:

    worked as advertised…thanks!

  32. Waziur says:

    Thanks a lot, I have been benefited for you.

  33. Anonymous says:

    The option is greyed out.

  34. Anonymous says:

    Great, its very helpfull

  35. Anonymous says:

    Thank you

  36. Anonymous says:


  37. Anonymous says:

    very nice reply thnaks for the help

  38. Anonymous says:


  39. Anonymous says:

    Great, helpful

  40. zoey says:

    thanks! that was very helpful

  41. ram chand says:

    thanks dear, i was facing this from so long

  42. Christian says:

    Many thanks for that quick fix!

  43. riekris says:

    It worked! thank you for this post. it is very helpful! 🙂

  44. Sandeep says:

    Great It works!

  45. dk says:

    Lovely it worked like charm…Tankz team !!

  46. Anonymous says:


  47. Anonymous says:

    Thanks its working

  48. Anonymous says:

    Thanks. It works.

  49. Anonymous says:

    i will be try it after that say my opinion

  50. vijay singh rathouir says:

    Thanks it was really helpfull for me..

  51. Anonymous says:

    Thanks so much, it’s working. keep posting sir.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: