Forum Discussion
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....
Good 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
The column the REF! item was in was likely deleted.