Pivot Table Details - Formula in data

[PatrickAllen]

I'd like to have a hyperlink be part of my pivot data details. Currently I have a pivot table and when I double click the cell to show details it all comes through ok (from SQL) but the column with my cell does not show as a clickable link. I've formatted it in SQL as =HYPERLINK("link", "description") but I think it is coming through as text and not being evaluated by Excel. If I click into the cell and then hit enter it is turned into a link so the formula itself is working.

Is there a better way to do this or a way to force Excel to evaluate this column when it opens? I've checked the formatting on the new sheet and it is "General."