Forum Discussion
Excel rewrites my hyperlinks to sharepoint
Hi, I transfered all my work files to OneDrive and encountered an issue. I use excel spreadsheets for worklist, where I use hyperlinks for pics, drawings etc for each workpiece we are currently w...
I have all my files synced to OneDrive so I too had the same issue of creating a hyperlink and it taking me to my OneDrive directory. Most useless!
I might have found a remedy to this now. I created a link using right link menu option under Bookmarks, when completed the cell hyperlink looked like this #Sheet1!A1, so I stuck that into quotation marks in =HYPERLINK("#Sheet1!A1") and it works as a clickable link. I needed to make A1 dynamic based on a cell where today's date falls, so I can even go one step further with =HYPERLINK("#Sheet1!"&A2) where A2 contains a cell reference of B4 for example so it'll evaluate as =HYPERLINK("#Sheet1!B4") and clicking it take me to cell B4 in Sheet 1.