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

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

  1. Anonymous says:

    Thanks it was really helpfull for me..

    Regards,
    Shikha

  2. Anonymous says:

    It worked 🙂

    Thanks
    Nilesh

  3. Anonymous says:

    Thanks I looked for it a long time 🙂

    udi

  4. Anonymous says:

    Thank you, Great

  5. Anonymous says:

    But permanently how to solve

  6. Anonymous says:

    Thanks. It was of tremendous help.

    Regards,
    Vipul

  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:

    awsome……~

    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:

    moshi…

    […]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:

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

  16. Sai babu says:

    Thanks

  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
    Rakesh

  35. Anonymous says:

    Thank you

  36. Anonymous says:

    Thanks.

  37. Anonymous says:

    very nice reply thnaks for the help

  38. Anonymous says:

    Excellent!

  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:

    Awsome

  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.

  52. Amit Upadhyay says:

    thanks dear

  53. Anonymous says:

    Thanking you very much

  54. yogesh rajput says:

    great its work thanks

  55. Asad Ali says:

    Thanks a tone, made my life easy !!!!

  56. Anonymous says:

    You are just great buddy…..it really helped…..god bless you…..made work easier.

  57. MANISH says:

    VERY HELP
    FULL ….

  58. Anonymous says:

    oh thanks alot
    you people are gem you help like this

  59. Anonymous says:

    it worked for me as well
    it has been 9 years and your post still helps people 🙂

  60. Anonymous says:

    Thanks much for the post 🙂

  61. Anonymous says:

    Thanks billion billion and billion more

  62. Anonymous says:

    Thanks this method is very help full

  63. Mohammed Adil Khan says:

    Thanks its very helpful for everyone

  64. Anonymous says:

    Good job

Leave a reply to dk Cancel reply