Dynamic hyperlink from cell to external URL stopped working

Mike Steiner

Hi guys,

 

I have been successfully using a formula to enter a hyperlink in a cell, using, for example, syntax like this:

 

="http://ServerName/Default?queryStringParameter=" + [Column Name]rownum 

 

This approach enables you to use the [Column Name]rownum syntax to dynamically create the URL based on the contents of other cells.

The actual value of the contents of the cell as determined by the formula was displayed as a blue-colored active hyperlink.

This has now stopped working, and the contents of the cell now displays as simple text, not a hyperlink.

 

This method served as a good workaround to the right-click => Hyperlink functionality of a cell, which shows a dialog box in which you need to define a static URL, and you can't use the [Column Name]rownum syntax.

 

What has changed to stop my workaround from creating an active hyperlink?

 

Thanx,

Mike Steiner

Mike Steiner

I figured out the issue!!

 

There was an underscore character in the ServerName "XXX_YYY_ZZZ_1" that was preventing SS from recognizing it as a correct hyperlink!!