调试经验—— Excel点击保存时总是弹出隐私信息警告（Privacy Warning:this document contains macros...）的解决方法

问题：

有一个Excel文件，每次点击“保存”按钮，都会弹出一个对话框，很是烦人。

" Privacy Warning:this document contains macros,ActiveX controls,XML expansion pack information or web components. these may include personal information that cannot be removed by the document Inspector."    

 

解决办法：

For Excel 2007 Version :
 You can follow the following steps to avoide the privacy warning.
 1 Menu Button "on the top left of the excel window"
 2 Excel Option
 3 Trust Center
 4 Trust Center setting
 5 Privacy Options 
 6 unmark the "Remove personal information from file properties on save"  

 

参考资料：

https://www.mrexcel.com/forum/excel-questions/519071-how-remove-privacy-warning.html