Why do I get the #NAME error?

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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.