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:


Click Trust Center and Trust Center Settings.

Active X Settings

Set enable all controls without restrictions.

Uncheck Safe mode.


Macro Settings

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

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


Protected View

Disable all protected view options.


This entry was written by Kent Willumsen , posted on Wednesday January 30 2013at 10:01 am , filed under Office Tools, Technical Knowledge and tagged , , , , , . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

Comments are closed.