To turn off Privacy Warning on Excel

When you open an Excel file with a macros, it usually comes with a Privacy warning message. So how to turn off Privacy warning notification in Excel?

When processing Excel files with macros or ActiveX Control, we will constantly see the Privacy Warning message. To open the file or save the data, the user must click the OK button to continue editing or importing the contents of the Excel file. Although this message does not affect the content, it is constantly annoying to users. So how to turn off Privacy Warning on Excel?

  1. How to fix Excel error 'The formula you typed contains an error'
  2. How to create duplicate data entry notifications on Excel
  3. Fix "File Error: data may have been lost" error in Excel

Instructions to turn off Privacy Warning on Excel

Notice Privacy Warning fully on Excel with Privacy Warning: This document contains macros, ActiveX controls, XML, Expansion pack information, or Web component . as shown below.

To turn off Privacy Warning on Excel Picture 1To turn off Privacy Warning on Excel Picture 1

Step 1:

Click on Options on Excel to enter the setting.

To turn off Privacy Warning on Excel Picture 2To turn off Privacy Warning on Excel Picture 2

Step 2:

In the new interface, click on Trust Center in the list on the left of the interface. Look to the right, click Trust Center Settings .

To turn off Privacy Warning on Excel Picture 3To turn off Privacy Warning on Excel Picture 3

Step 3:

Switch to the next interface and click on the Privacy Options section on the left side of the interface. Look to the right to remove the space at the line Remove personal information from file properties on save . Finally click OK to save.

To turn off Privacy Warning on Excel Picture 4To turn off Privacy Warning on Excel Picture 4

See more:

  1. How to fix Errors were detected while saving files in Excel 2010
  2. Fix the error "The document is locked for editing by another user" when opening a Word document
  3. How to fix date errors when copying to another Excel file

Hope this article is useful to you!

4.3 ★ | 4 Vote