Jira Cloud to excel no longer linking to key - formatting looks like links

[Rachel Young]

Hello! 

When I first imported my jira project into an excel sheet, the Key column was linking directly to each issue in Jira. However, now there are no links in the document. Additionally, all 3 columns A, B and C are formatting to look like links (blue text, underlined), but are not links. Is there a way to at least have all the text look the same? 

I didn't change anything with the sheet and have reimported the project and am still getting the same results. 

[Bill Ketchel]

Did you ever get this solved?  I'm having same issue and it appears to be related to importing the data as a table vs name range.   If you import as a table the the hyperlinks are lost. 

[John Funk]

Hi Rachel - Welcome to the Atlassian Community!

It might just be with your Excel setup. I am not an expert on that at all so you would need to do some Googling. But if you right click on one of the values in the Key column, you should be able to select Edit Hyperlink (or maybe even Open Hyperlink). If you do the Edit Hyperlink, see what value is in the Address field. If there is a value there, you just need to click on OK and it should make it a link in your sheet.