How to create an Excel hyperlink connected to a local file on iPad?

Question

Hi. I wish to replicate a simple function I use on Windows all the time.

EXAMPLE: Using Excel (Office 365) on an iPad Pro, I save the Excel file in a local folder. I save a PDF file in the same folder. I confirm their existence using iPad Files app. I can open the PDF file directly from within the Files app.

Within the Excel file, I type the file name in cell A1, and type "=hyperlink(A1)" in cellA2. When I click on A2, then click link, then Open, i get the message, "Sorry, we couldn't open this link. The link address may be invalid, or you may not have permission to open it."

I need to link to local files, not cloud-based files, because I will not have Internet access when using this Excel file. And I wish to use relative links rather than absolute links showing the file folder structure so that when finished, I can share the entire folder with all linked files and know that the hyperlinks will work.

What am I missing, and how can I accomplish this, please? If you can help me with this, you will have made my entire year. Thanks.

Answer 1

NOTE: When using the Insert > Link function within Excel on the iPad, the only option is to type in the linked file name. Excel does not provide the same popup window that is common to Windows and Mac that allows you to explore the folder structure and select a desired file to link to.

Perhaps someone knows how to advise me on what local URL address I would use for an absolute/fixed local link (including the folder structure before the file name).

Thanks.