=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.
Posted in: Trouble-Shooting
Sorry, the comment form is closed at this time.