Hi,
I have a formula in a cell which creates a hyperlink to google maps, and displays the "SUBURB STATE" as the actual cell text.
This is the formula;
Formula:Please Login or Register to view this content.
If you click the link it takes you to google maps and displays the suburb with a border and shading to indicate the shape of the suburb.
This works fine.
However I would like the hyperlinks to google maps to be available in a pivot table, so if I am investigating where a trend or outlier is located I can click the location and bring it up in google maps.
Any ideas?
Thanks
Bookmarks