Decided to gather all Excel settings in one place for my own sake really.
It might be redundant with some existing posts here but I like it to be easily accessible.
The settings below should work with the latest versions of Excel – so far 2007; 2010 and 2012.
Pictures below are from Excel 2010.
Open Excel and click File and then click Options:
Click Trust Center and Trust Center Settings.
Active X Settings
Set enable all controls without restrictions.
Uncheck Safe mode.
Enable All Macros (as WebADI macros are not signed).
Enable "Trust Access to the VBA project object model".
Disable all protected view options.