Functions from a Data Source

[Joe H]

I store Function in a table such as:
=HYPERLINK("www.google.com","Google")

But when I connect to the data source and display it - it actually displays:
"=HYPERLINK("www.google.com","Google")"

Instead, I want it to actually be the Excel function and only the work
"Google" would show up as a hyperlink.

 

[FloMM2]

Joe,
Try this:
In the cell that you want the hyperlink (C4).
Select C4.
Select "Insert".
Select "Hyperlink".
In the box Text to display:Google
In the Address: www.google.com
hth