To turn off Privacy Warning on 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?
- How to fix Excel error 'The formula you typed contains an error'
- How to create duplicate data entry notifications on Excel
- 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.
Step 1:
Click on Options on Excel to enter the setting.
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 .
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.
See more:
- How to fix Errors were detected while saving files in Excel 2010
- Fix the error "The document is locked for editing by another user" when opening a Word document
- How to fix date errors when copying to another Excel file
Hope this article is useful to you!
You should read it
- How to fix Vietnamese error when opening CSV file in Excel
- 6 ways to fix Excel error not displaying spreadsheet content
- 7 most common Excel errors for office people
- How to fix Autofill errors in Excel
- How to fix the SUM function doesn't add up in Excel
- Common causes of Excel workbook errors
- How to fix Errors were detected while saving files in Excel 2010
- How to fix Value errors in Excel
- Get started with Excel for beginners
- Fix error when Excel file is minimized
- Common mistakes in Excel and how to fix them
- Tips for adding in Excel you need to know