Solution to pop-up privacy issues warning for Excel files

When using Excel, we often encounter an Excel file pop-up privacy warning, the problem should be to save the Excel table contains personal information, and this information can not be saved so as to cause the hint, there is another reason may include some irregular VBA code, Remove the hint by removing the VBA code or the control code.

Operation Steps

1, Punch the Excel table click the menu bar "Tools" → "Options".

2, into the "Options" settings, click "Security" under the "Personal information options" to tick off "save from the file properties to remove personal information" to solve the problem.

3, there is another way to use VBA code to solve this problem, press ALT+F11 into the VBA interface, select ThisWorkbook.

4, in the "ThisWorkbook" window to enter the following code, and then turn off excel in the open.

Private Sub Workbook_beforesave (ByVal SaveAsUi As Boolean, Cancel as Boolean)

Activeworkbook.removepersonalinformation = False

End Sub