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?

Improve this question
2

2 Answers 2

Reset to default
36

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
2
  • 3
    Excellent! But why oh why do Microsoft make this so amazingly complicated?!
    – Reinstate Monica - Goodbye SE
    Jan 12, 2012 at 14:14
  • 2
    Step 4a. Privacy Options
    – onewhaleid
    Nov 23, 2016 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
3
  • 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, 2012 at 10:48
  • 1
    I guess you didn't check the link that I provided...
    – thane
    Jan 16, 2012 at 7:01
  • Indeed, I did not notice it. Thanks!
    – Reinstate Monica - Goodbye SE
    Jan 16, 2012 at 8:31

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .