nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Rachel Peterson

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

Resolved.

All comments

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!

Chris_9zuhpb

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

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

Screenshot 2023-07-18 at 00.34.56.png

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.

Rachel Peterson

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

Resolving this.

Rachel Peterson

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

Resolved.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud