Excel for E-Business Suite

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:

image

Click Trust Center and Trust Center Settings.

Active X Settings

Set enable all controls without restrictions.

Uncheck Safe mode.

image

Macro Settings

Enable All Macros (as WebADI macros are not signed).

Enable "Trust Access to the VBA project object model".

image

Protected View

Disable all protected view options.

image