I have a workbook with hyperlinks that point to ranges in different sheets in the same workbook.
The hyperlinks worked fine as long as the file was in a shared drive.
I uploaded the file to SharePoint, and now the hyperlinks prompt me to open the same file again, creating a lot of problems.
Have you had this problem? How do I fix it or avoid it?