Forum Discussion
sammary
Nov 16, 2023Copper Contributor
Local links
I'm up to date on all my updates and I'm using Office365 on Windows 11. I'm using OneDrive and I have all files downloaded onto my hard drive.
When I create a link in an Excel file the link appears to be connected to the OneDrive version of the file rather than the local version. How can I force the link to refer to the local drive?
The work around that I'm using is to place my computer in airplane mode, create the link, close the file, go on-line and open the file. It works but it is sill to have to do this.
I'm getting a similar problem when I open an Excel file, it takes a while. A green bar at the bottom of the screen during the open process appears to be trying to open the file from OneDrive and not the local drive.
Thanks
16 Replies
- JKPieterseSilver ContributorWell, that is how OneDrive works; you link to a file on OneDrive and Excel has a strong preference to refer to the on-line version rather than the one on your system. I don't think there is much you can do about this.
- sammaryCopper ContributorAs I recall good programming practices is to minimize network references for the sake of efficiencies. When the local drive and the network drive contain the same information, then the logical choice should be to go to the local drive.
- JKPieterseSilver ContributorUnfortunately that isn't how things work ๐
The choice for using https links starts to make sense if you consider the CoAuthoring experience: changes made to the file must be sent to the server so that other end-points are notified and other users see your changes. That is the probably the reason for the preference for the https addresses over the local folder address.