Hi,
I have a problem which was resolved before, but the solution previously used doesn't work anymore for whatever reason.
I have a Google Sheet with multiple hyperlinks per cell (see attached screenshot). I have to copy and paste the words with the related hyperlink in a table in Indesign (see attached).
Hyperlinks are not automatically pasted from Google Sheets to Indesign. In the past I used to copy every single cell in Microsoft Words and copy the words with the links from there to Indesign. This solution worked and allowed me to copy both text and hyperlinks. This solution doesn't seem to work anymore. I have tried to download the Sheet as an .xlsl file. If I open the .xlsl file with Numbers (I am on a Mac), the whole cell only retains the first hyperlink, so all words copied into Indesign are subsequently all linked to the same hyperlink within a cell. If I open the file with Microsoft Excel for web, it copies the words but not the hyperlinks.
I am at a loss, it is a 50 pages document so I cannot waste weeks copying and pasting every hyperlink to the document. Does anyone have a workaround or a solution?
Thank you!
<Title renamed by MOD>
1
Reply
AdChoices
