I've created a calculated field to produce a result that should be a
clickable HYPERLINK when exported to Excel:
Sample Result: =HYPERLINK("http://www.fedex.com/Tracking?
tracknumbers=xxxxxxxxx","Click to Track")
When I export to Excel, and open in Excel, the field is not clickable
as it should be. If I hand type the exact same text into Excel it
works as it is supposed to.
When I export to CSV, and open in Excel, the field is clickable but
not formatted in blue and underlined as it should be if hand typed in
Excel. CSV exports also have the problem of no column headers.
Any suggestions?
-----------------------------------------
Andrew Kappy
I.T. Director
Canfield & Tack
Quality Printers Since 1926
925 Exchange Street
Rochester, New York 14608
585-235-7710 ext. 142
