1

I'm trying to get my URLs in my Pivot Table / Pivot Chart to display as hyperlinks.

I've set up a connection, "From Other Sources," in my case Oracle. In the SQL statement, I say,

SELECT '=HYPERLINK("http://www.google.com?' || otherStuff || '", "Pretty Name")';

This would return to my workbook: =HYPERLINK("http://www.google.com?1234567890", "Pretty Name")

However, this stays as text in Excel ( the string "=HYPERLINK...Name")" ). I want it to switch to "Pretty Name."

Any ideas?

Randall
  • 17
  • 3
  • What is the version of Microsoft Excel you're using? Also, are you trying to put this formula using VBA or other thing? If possible, please explain with more details. – Octopus Mar 18 '13 at 18:34
  • Excel 2010. No VBA currently being used. – Randall Mar 18 '13 at 18:49
  • I can get it to convert to the "Friendly Name" -- but only if I edit the field (F2), then hit Enter (because it thinks I'm hand-jamming the =Hyperlink() function in as a user). There is no "Format cell...as URL" type; it's merely general (or text). – Randall Mar 18 '13 at 18:51
  • You might take a look at: http://stackoverflow.com/questions/4471884/turn-a-string-formula-into-a-real-formula – Jane Panda Mar 18 '13 at 23:05

0 Answers0