Excel for Android issues.

[Richard Silen]

I have MS Word and Excel for Android on my new Android tablet (Samsung) I'm a musician who wants to use it on stage. On a Win PC I worked out an elegant little spreadsheet that allows me to see my set lists and punch up the charts for it with a tap using a hyperlink to a docx file. No problem works great. But when I uploaded the entire directory containing the excel file and the word files to my external storage on my tablet, the hyperlinks failed. When I figured I could simply edit the spreadsheet under android version of Excel and establish new hyperlinks. Then the problem arose that I could NOT come up with android device local file addresses that worked for the docx addresses. Hyperlinks seemingly only want to address urls or cloud addresses, not local device/storage files. Help!!!!

 

[Kenneth Hobson]

Welcome to the forum!

Does this help? https://social.msdn.microsoft.com/F...ile-format-for-a-relative-file?forum=exceldev

 

[Richard Silen]

Welcome to the forum!

Does this help? https://social.msdn.microsoft.com/F...ile-format-for-a-relative-file?forum=exceldev

Thanks for the reply. I'm not quite sure if it works yet, will test out tomorrow. The term "relative" is used. I take that to mean that the value of the address changes as the addressing moves from one device to another. Is that just a simple "///". I'm not an Excel guru and was hoping there was a simpler answer than what appears to be almost a coding solution.

 

[Kim Wainwright]

Hi Richard, Sorry for the late entry into this thread. I have exactly the same problem as you posted above. Did you get a solution?