Forum Discussion
JAVIER CUESTA MARISCAL
Aug 15, 2017Copper Contributor
EXCEL automatically replaces the local path in hyperlinks by the online ones
This behavior is really disruptive. The worst is that EXCEL does the same when you link to local computer OUT of the OneDrive folder in the local C: root. and not only for files but also for FOLDERS. I understand that this is not quite correct, and can never work. I realized when I moved some working folders in which I move files around using macros out from OneDrive and relocated in a Local Library within "My Documents" trying to work this around. I got really surprised that instead of the hyperlink pointing to the local folder, it "invented" a location replacing the first part of the path by the SharePoint site string.
My conclusion is that this is NOT a "functionality" nor a "behavior", but a simple and plane BUG instead. The fact that this is being dragged from 2015 suggests that this BUG is driven by an unacceptable and not very subtle SPAM practice to "encourage" people to work in the cloud OneDrive version of the documents and locations. It would be nice that we could work 100% cloud, and we users appreciate your efforts to put the means in place to get there but unfortunately, we aren't there yet. This also clashes the spirit of building the structures within companies from the base to the top in a user self-service way. I'm trying to automate some processes for my team and this behavior prevents me from doing it in a straight and simple way. It doesn't look professional and a program as Excel DO NOT deserve to hold these tricks. I think that you MS guys would do better fixing it for the time being. At least to give an option to switch off this automated swap. I have searched this for long now, but If it is already in place eventually accept my apologies and please by all means show me how to do it. Thank you
3 Replies
Sort By
- Arnie StroebelCopper ContributorGood day all, I have a spreadsheet making use of Vlookup, and the formula is coming up with the following error, =VLOOKUP(#REF!,DATA!$A$1:$R$2423,2,FALSE) Can anybody please assist with a solution, or perhaps explain what the problem might be
- Brian SpillerBrass ContributorThe column the REF! item was in was likely deleted.
- Brian SpillerBrass Contributor
As a fellow user, I can see the problems with this.
My work environment doesn't even acknolwedge we have OneDrive for Business through SharePoint !
I'm sure the behaviour is quite intentional as the link can only point to one location and the assumption being made is that the OneDrive is the best file. Also, if the file making the reference is placed in a OneDrive location and opened by another user, it will still see the correct location. This avoids bad mapping of Network shares.
The problem with MS implementation is that it assumes that OneDrive is the source and not merely the tool to share ertain files.
When working offline, do the links still work or are they failing when there is no Internet connection?