Monday, 30 April 2018

Disable Pop up in Excel - Parts of your document may include personal information that can't be removed by the Document Inspector

Hi,

Are you facing the below pop up when you try to save an Excel file?

Message : Be Careful! Parts of your document may include personal information that can't be removed by the Document Inspector



You can disable this pop by doing below change:

Excel Options->Trust Centre->Trust Centre Setting at Right Middle->Privacy Options - >A checkbox "Remove Personal ..." at middle.Uncheck it.

or

by VBA

Thisworkbook.RemovePersonalInformation=False