26

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?

35

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
| improve this answer | |
  • 3
    Excellent! But why oh why do Microsoft make this so amazingly complicated?! – Reinstate Monica - Goodbye SE Jan 12 '12 at 14:14
  • 2
    Step 4a. Privacy Options – onewhaleid Nov 23 '16 at 22:21
5

Try this:

Office Orb > Excel Options > Trust Center/Trust Center Settings > Document-specific Settings

Uncheck "Remove personal information from file properties on save"

1

| improve this answer | |
  • 1
    I don't see this option. I see Office Orb > Excel Options > Trust Center > Trust Center Settings (new dialog): no Document-specific Settings. On the left side I see a list from Trusted Publishers to Privacy Options. – Reinstate Monica - Goodbye SE Jan 12 '12 at 10:48
  • 1
    I guess you didn't check the link that I provided... – thane Jan 16 '12 at 7:01
  • Indeed, I did not notice it. Thanks! – Reinstate Monica - Goodbye SE Jan 16 '12 at 8:31

Not the answer you're looking for? Browse other questions tagged or ask your own question.