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...
Any solution to this? I have been working on a huge index to link to various files and all of the links just changed to the sharepoint link. I want to open the local file that I linked to, not some online version through a browser. I put so much work into this index, only to have the whole thing destroyed by this.
don242can unfortunately, I have not seen a resolution to this issue. Sorry to hear it has set you back.
- Fverley1223 thanks for the reply. The links were holding for a few weeks of working on this but suddenly today they all pointed to the sharepoint. Completely defeated now.
Maybe this will work
Make vCommand a Variant
Instead of Dim vCommand as String, use Dim vCommand as Variant
