Hyperlink from within an Active Form?

[sjokesson]

I've built an active form containing a list of products. I'd like one of the columns to contain a hyperlink to a vendor's website.

So, I inserted a column in the active form having the Excel "hyperlink" formula. It references two columns (which will be hidden from the user), containing the URL and common name. When I build this formula in row 1 everything looks great-- the hyperlink changes to blue and is underlined. When I rebuild the sheet, however, the hyperlink reverts to plain text. I've played with the format section but to no avail.

This seems like it should be possible, shouldn't it? I've attached a values-only Excel file showing what I'm trying to do.

[lotsaram]

It works just fine for me. Are you sure its not just because you have the number format of your hyperlink formula set to Text?

[sjokesson]

Lotsaram, thanks-- I tried again and it worked. URLs in my Active Form will be a nice new feature.