FAQ/excmac - CBU statistics Wiki
location: FAQ / excmac

Why do I get a NAME? appearing in cells when I try to run an EXCEL spreadsheet program?

Upon first using a new version of EXCEL you may get a NAME? appearing in ceertain cells (e.g. computing p-values for one of the spreadsheets handling multiple comparisons). This is most likely caused by EXCEL having a security setting which bars it from using the in-built macros which are used to compute the statistics of interest in these cells.

If this is the case you need to change the macros security setting within EXCEL (unless a system administrator in your organization has changed the default settings to prevent you from changing the settings). This setting is retained on successive visits to EXCEL so only needs to be done once.

To do this using EXCEL 2007

  1. On the Developer tab, in the Code group, click Macro Security.

(Tip If the Developer tab is not displayed, click the Microsoft Office Button , click Excel Options, and then in the Popular category, under Top options for working with Excel, click Show Developer tab in the Ribbon).

  1. In the Macro Settings category, under Macro Settings, click Enable all macros.

(This can also be done similarly using older versions of EXCEL. Press the F1 button and look up 'macro security settings' for further details).

None: FAQ/excmac (last edited 2013-03-08 10:17:37 by localhost)