Friday, September 29, 2017

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:


Excel privacy warning


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?


Answer



Disable document inspector in the Trust Center.


Note: picture may not be exact as I use Office 2010.


Excel Options


Step by step instructions (for 2007):



  1. Office orb

  2. Excel options

  3. Trust Center

  4. Trust Center Settings...

  5. Uncheck Remove personal information from file properties on save

  6. OK

  7. OK


No comments:

Post a Comment

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...