Maybe a little odd question but,
When I open a Excel file located on "onedrive" using my browser but open it in Excel2013 (not excel on-line) the below formula replies the actual web address of the file.
=SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),"[","")
gives
https://d.docs.live.net/e6f2cc6xxx3198e6/Filelocationtest.xlsx
For me this is very handy. ondrive seems to be the only cloud-service that works like this. All other clouds first save the file on a local drive and open it with Excel.
I'm looking for a alteative to onedrive.
Q1: Does anyone know a alteative to onedrive what works the same? Q2: And does this file handling/system has a name?
Cheers