I hope someone can help me, I've been pulling my hair out on this one...
I'm trying to set up a hyperlink in Indesign, to link to a specific sheet in one Excel file. I don't want to import the excel file within indesign, I just want that file to open in Excel when the link is clicked on in the final exported PDF. Well I've managed to link to the general Excel file, but not to one of the specific sheets within that file...
Also, the final pdf and the Excel doc will be sent out via email - when I create the hyperlink, Indesign wants the complete/absolute file path to the external doc, how will that work when I send it out by email. Will the link work for the third party?
A huge thank you to anyone who can point me in the good direction....
If the Excel file resides on the web, you can use:
The default action in Excel is to open with the last active cell. So the a1 at the end positions the view to the top left. You can also open to named sections.
Also, keep the filename.xls and sheet names without spaces. However, for a sheet name with a space, enclose it in single quote marks like 'Sheet Name'
Take care, Mike
Unfortunately, the files won't reside on the web, they'll both be sent out via email...
I've tried what you suggested and it worked from word but I couldn't make it work from Indesign,
Have you tried this yourself?
Thanks so much,