Save As HTML & Retain Links [About to Rage]

[callumogrady]

Hello,

I have created a spreadsheet that takes GPS co-ordinates from a cell,
And opens them with a =HYPERLINK function on Google Maps

=HYPERLINK(" http://maps.google.com/maps?z=18&q="&D1,"Open in Maps")

When I save this as a HTML file,
The links do not save correctly and end up looking like this.

file:///C:/Users/Callum%20O'Grady/Desktop/hello!_files/%20http:/maps.google.com/maps?z=18&q=-28.8938648%20152.5067573

I have tried to set the Hyperlink Base to X,
I have unchecked links to Update on Save

I have attached my work book, I'm out of options and have no where else to go,
Please any advice would be great!


assets.xlsx

[ben_hensel]

Trying to do a concatenate function inside the hyperlink function is screwing you up.

There's a simple fix:

D1 = "http://maps.google.com/maps?z=18&q="&B1&" "&C1
E1 = HYPERLINK(D1,"Open in Maps")

Now when you save to HTM the links should work.

[callumogrady]

Perfect!
That worked great thank you very much.

I am now trying to get this to work in a .PDF file.
Seems to be giving me a bit of grief as it will only display a straight Hyperlink,
For example http://www.google.com

If I start trying to use my cell references in the formula, it doesn't recognise as a Hyperlink when opening.

assets2.xlsx