Forum Discussion
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 ...
As 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.
Unfortunately 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.
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.
- Performance 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.- This morning at 0530, with my whole family sleeping (i.e. nobody was using bandwidth) it too approximately 58 seconds to open an Excel file that is 52K
- Does the Excel file contain any external links? (make sure you check range names and hidden range names too)