Trying to copy hyperlinked items from Excel

[Rachel Peterson]

I have an Excel sheet that has hyperlinked items in it.  When I copy and paste it into a Confluence page, it creates a table with all the items but all the hyperlinks are lost.  Has anyone been able to get this to work?  If so, how?  

NOTE: I can't just re-link everything because this table has 40+ links in it and I have to re-paste the data every month so manually re-linking is not preferable.  

Update: It only don't transfer hyperlinks that were built by a formula.  It works properly for engrained hyperlinks.  

Update 2: It transfers out the link just fine if you C&P from desktop Excel but not web-based Excel. 

Resolving this.  

[Rachel Peterson · Accepted solution]

Update: It only don't transfer hyperlinks that were built by a formula.  It works properly for engrained hyperlinks.  

Resolved.

[Chris]

Hi,

did you try to embed it? Just drag an drop the sheet into a confluence page.

I`ve tested it, it keeps all the links.

[Rachel Peterson]

Update: It only don't transfer hyperlinks that were built by a formula.  It works properly for engrained hyperlinks.  

Resolving this.  

[Linh Pham_Ricksoft_Inc]

Hi Rachel, the hyperlinked items should persist when copying from a Sheet. You could also try to create a table on a Confluence page first and then paste the value from your sheet. I hope it works! 

[Rachel Peterson]

Tried that.  No dice.  

[Linh Pham_Ricksoft_Inc]

Hmm that's really weird... Perhaps another option is as @Chris mentioned above. You can embed the file directly on the page using the Office Excel macro 

Or another workaround, which is a little tedious, if you were trying to copy from a local file and doesn't work. I'd suggest uploading the file to Google Sheet and copy from there, it worked when I tested it.