Disable Word and Excel storing your personal information

Costas

Administrator
Staff member
As LibreOffice / OpenOffice also Microsoft Office every time creates a new document, is using a template file. By default is to
%appdata%\Microsoft\Templates

with the filename Normal.dotm.

1- Close any Word instance
2- Open Word application. Within Word open the %appdata%\Microsoft\Templates\Normal.dotm
3- Press ALT+F11 or open the VBA editor
4- Turn the RemovePersonalInformation property TRUE

KYfdLLY.png

5- At VBA Editor > Save, close it.
6- At Word > Save, close the application.


source

reference - How to remove personal info - per document



EXCEL from the other hand, is not using a template by default. But we can make it use a template file by saving it as Book.xltm
to C:\Program Files\Microsoft Office\Office14\XLSTART directory (which by default is empty).

doing the same customization as Word, results inside EXCEL template file, we made at .\xl\workbook.xml
a new keyvalue
filterPrivacy="1"

8RyQahq.png
On later versions of Office 2010, user can set the templates directory under File > Options > Save > 'Default personal templates location', user has to set the C:\Program Files\Microsoft Office\Office14\XLSTART there so will be used as default template.

On Office 2010, there is no option 'Default personal templates location', and EXCEL is using by default the C:\Program Files\Microsoft Office\Office14\XLSTART.

ps : maybe needed to startup 2 times, so make use of template.

reference - Automatically open a workbook template
 
Top