Hyperlink Issue - Specifically Google?

Six_of_Ten · Jul 11th 2019

Hello all,

Is anyone aware of any changes to the way Google Map links work within Excel? I have a large spreadsheet setup which uses various mapping sites to help identify key information. Yesterday, a hyperlink to Google Maps become non functional, while other links (Open Street Map, Street Map, Grid Refernce) are still working fine. Please see the attached image showing the error message, as well as hyperlink formula.

Is this an issue within Excel or have Google changed the way their maps work? Searching online has revealed that there are either Internet Explorer (work offline, no longer present in IE11), or registry issues, however, as some hyperlinks are working and not others, I don't believe this to be the issue. Firefox is the default browser.

[ATTACH=JSON]{"data-align":"center","data-size":"full","title":"screenshot_02.png","data-attachmentid":1220275}[/ATTACH]

**AliGW** · Jul 11th 2019

Could this have anything to do with having to pay once you exceed a certain number of hits? Google introduced this some time ago: https://manifesto.co.uk/google-maps-api-pricing-changes/

Six_of_Ten · Jul 11th 2019

Ah, that might be it. This may be a problem...

**S O** · Jul 11th 2019

check out https://www.openstreetmap.org - it's an open source alternative and I'm seeing it getting used more and more in web development

Six_of_Ten · Jul 16th 2019

Having had a play around, I've discovered it was possibly an update by Google which caused it. Trying this new hyperlink has got it working once again.

=HYPERLINK("http://maps.google.co.uk/maps/place/"& L5 & "," & N5, "Click Here")

**S O** · Jul 16th 2019

glad to see you got it working mate! and thanks for letting us know

Hyperlink Issue - Specifically Google?

Participate now!

Share