When Excel tables are saved, you are prompted that this document contains macros, ActiveX controls cannot be saved

A dialog box pops up each time you save Excel, prompting the privacy issue warning: This document contains macros, ActiveX controls, XML expansion pack information, or Web builds. They may contain personal information that cannot be removed by setting the "Remove personal information from file properties" On the Security tab of the Options dialog box on the Tools menu. If you click Cancel, the Prompt "This document is not saved", each time have to click to confirm a bit cumbersome, as long as the set can remove the hint.

1, first click on the top left of the Excel panel icon, here to EXCEL2007 as an example.

2, click on the bottom right corner of the "Excel Options" to enter the settings of Excel.

3, in the pop-up window select the left side of the "Trust Center."

4, click on the right side of the option to enter the "Trust Center settings."

5, in the new pop-up interface to the left click "Personal Information Options", the right side of the "save from the file properties to delete personal information" before the hook removed.

6, then click Save again, there will be no hint.

7, there may not be their own Excel settings have a problem, but the other side sent over the file defaults set this option, because not to save all problems will prompt this problem, the setting is for a single file instead of all, let the other side check his Excel settings can avoid recurring problems.