I can no longer open the hyperlinks on other computers.

[16592181]

Dropboxを使い始めて、MacBook Airにインストールしました。Excelファイルを他のパソコンと同期していますが、Macにインストールしてから、ハイパーリンクが他のパソコンで開けなくなりました。問題はファイルパスや相対パスと考えられます。共有リンクに変更する方法がありますが、多くのファイルがあるため、それは難しいです。他に良い解決策があれば教えてください。

I started using Dropbox and installed it on my MacBook Air. I am syncing Excel files with other computers, but since installing it on the Mac, I can no longer open the hyperlinks on other computers. The issue is believed to be related to file paths or relative paths. There is a method to change the links to shared links, but it is difficult due to the large number of files. Please let me know if there is any better solution.

[Hannah]

Hey @16592181, thanks for reaching out to our Community.

Are these hyperlinks saved in your Excel files?

Also, what kind of files do these hyperlinks direct to? Other files in your Dropbox folder?

Are you only having this issue on your local Dropbox folder or on our website as well?

And why are you not able to open them? Are you getting some kind of error message?

Thanks in advance for this info.

[16592181]

Thank you for contacting us.

In Dropbox, there are many PDF files in addition to Excel files, and their hyperlinks are set in Excel cells.

On a Mac, when you click on a hyperlink, you may see a message saying, "The file may contain viruses that could affect your computer," but pressing OK allows you to open the file.

On the other hand, on Windows computers, you see a message saying "Cannot open" and cannot open the PDF files with hyperlinks.

[Hannah]

Thanks for your response!

Are these hyperlinks from local files (local file paths) or URLs from the files on dropbox.com?

[16592181]

Thank you for your message.

The hyperlinks were created using PDF files located in the Finder on the installed Mac.

On the other hand, hyperlinks created on other Windows computers before using the Mac can no longer be opened on Windows computers either.

[Hannah]

Thanks!

And can you let me know a bit more about the process you're following to create the hyperlinks?

[16592181]

First, right-click on the cell where you want to add a hyperlink.

Next, select "Hyperlink" and click on it to display the "Insert Hyperlink" tab.

From this screen, select the PDF file synced with Dropbox and click "OK." This is the process for creating a hyperlink.

However, only two files were created using this method, while the remaining 600+ files were created on a Windows computer.

Both the hyperlinks created on a Mac and those created on Windows can no longer be opened on Windows computers.

[Walter · Accepted solution]

Hey @16592181, sorry to jump in here, but I just wanted to mention that this is happening probably because the hyperlinks you created on your Mac point to your local files on your computer.

Since this set-up would be device specific, any other users or devices that would try to access those hyperlinks would get an error. 

You can also have a look at this discussion for more information. 

[16592181]

Thank you for your message. And thank you for sending the URL of the previous question as well. It turns out that the issue is exactly the same as the one in this URL. From this question, I understood that it is difficult to share hyperlinks with colleagues using Windows computers when installed on a Mac. Therefore, this time I chose not to sync using a Mac.