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 ...
JKPieterse
Nov 17, 2023Silver Contributor
Well, 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.
- sammaryNov 17, 2023Copper 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.
- JKPieterseNov 20, 2023Silver 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.- sammaryNov 20, 2023Copper ContributorPerformance has always been read local, write remote (this is what we also did when I managed trading systems). With network speeds being what they are the write is almost immediate which should satisfy Coauthoring.
The dark side of reading from OneDrive, at least for me, is that there are times when it has taken 10-20 seconds to open a Word or Excel file. This is not my network being slow because I don't see this performance degradation with any other application.