Thank you for your question. I am Shefin and I look forward to helping you with your issue today.
The quick fix is to change or add a "hyperlink base."
Go to file, properties, summary and enter your new base in the "hyperlink base" field.
For example, if all your linked documents are found in the "documents" folder (even if in subfolders), change your hyperlink base to the following path:
/Users/yourusername/Documents/. Obviously, "yourusername" refers to your own username.
This new path subverts the automatic "hyperlink base" (if kept blank), which refers to the same folder in which you've created your spreadsheet (as you notice when you hover over the hyperlink).
If the issue persists, or you have any questions, please be back and let me know.
If you appreciate my service, please rate it EXCELLENT by clicking the EXCELLENT (5 Stars) and Submit. My goal is to provide you with excellent service – if you feel you have gotten anything less, please reply back, I am happy to address follow-up questions. Thank you for your business!
S H E F I N