Excel 2016 - 3D Maps cant find addresses in Japan.

[kombarris]

Hi!

I'm using the Excel 3D Mapping function and I'm struggling to make it work with Japanese addresses.

I can get it to work fine with US/UK addresses and of course if I specify the longitude and latitude for each Japanese address this works fine too. One work around that I've got is to call the Google Geocode API and using the WEBSERVICE function in Excel parse the Longitude and Latitude but I would like to avoid this if possible.

Any feedback or ideas would be appreciated!

Cheers!