If the functions return a #NAME error, it's probably due to Excel's security settings preventing the execution of macros. Lower the security level from Excel's options:

  • In Windows Excel 2007 and later, go to Excel Options: Trust Center: Trust Center Settings: Macro Settings. Select the last or the second last option. Restart Excel. Click "Enable macros" if prompted.
  • In Windows Excel 2003, go to Tools: Macros: Security. Select "High", "Medium" or "Low". Restart Excel. Click "Enable macros" if prompted.


Another possible cause for this error is misspelling the name of the function.