=geocode(“latitude”,”London”) returns #NAME


This is usually due to problems with Regional Settings.

I haven’t managed to identify exactly what makes this happen, but the problem occurs when your Office Primary Editing Language has been changed and/or doesn’t match the Regional Settings in the Control Panel.

First of all, try Geodesix Toolbar -> Options -> Advanced -> Force EN-US and restart Excel.

If that doesn’t solve it, set your Office Primary Language back to it’s original installation value. Do the same with the Windows language, or try EN-US. Or vice-versa. Sorry I can’t be more precise, everybody who’s solved this problem reports a different solution.