hyperlinks

[lump88]

    i created several hyperlinks in a worksheet. i want them all the same name, but go to different files so i followed the instructions from the help section in the advanced settings. it worked for the next three, but then i had to start to cleverly renaming them for some reason. 

    question two. how do i get the hyperlinks to work after i share them with my phone through the Office app (android) Thanks, Ron

[#2]

* Add a MS Excel file (without sensitive data) to your project. Knowing the Excel version and operating system would also be an advantage. Thank you for your understanding and patience Nikolino I know I don't know anything (Socrates)

[#3]

@NikolinoDE thanks for the reply. iam using Windows 10 and Excel V2010 (which i own)

[#4]

Hi @lump88 

Copy the files into the same folder as your excel file, then make the links in excel.

Once you want to share your excel file, share the whole folder (copy it).

[#5]

@lump88 

To question 1.

Formula =HYPERLINK(H9,"INFO")

http://www.Nikolino.de/topichyperlink

INFO

File with example attached

Regarding question 2. I can't comment because I don't know my way around. But can send you some information about it, maybe this will help you.

Install and set up Office on an Android

https://support.microsoft.com/en-us/office/install-and-set-up-office-on-an-android-cafe9d6f-8b0c-4b0...

Share and collaborate on files in Office for Android

https://support.microsoft.com/en-us/office/share-and-collaborate-on-files-in-office-for-android-f74a...

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.