How can I prevent the privacy warning in Excel?
I have Excel 2007. When I want to save a spreadsheet, I often see this message:
I've seen this with macro spreadsheets (using the .xlsm extension) and with non-macro sheets (using the .xlsx extension).
How can I prevent this warning every time I save my spreadsheet?
Solution 1:
Disable document inspector in the Trust Center.
Note: picture may not be exact as I use Office 2010.
Step by step instructions (for 2007):
- Office orb
- Excel options
- Trust Center
- Trust Center Settings...
- Uncheck Remove personal information from file properties on save
- OK
- OK
Solution 2:
Try this:
Office Orb > Excel Options > Trust Center/Trust Center Settings > Document-specific Settings
Uncheck "Remove personal information from file properties on save"