Hello!
I've been looking for answer already for some time without success... so here is my question:
How to share between users (on different PCs) an excel file containing external references (VLOOKUPs on another file) and not having to edit the link each time we open the file (updated by the other user) ?
Actually, we are using a "dropbox" with several excel files located in different directories. So the relative path is the same at 2 levels but... excel looks like storing the full path... so the full path will be different depending on the user.
Is it possible to store the relative path ? Is there a turnaround ?
My config: Excel 2013, Windows 7.
Any help would be GREAT!
Thanks!!!
Yours, Joao.
I've been looking for answer already for some time without success... so here is my question:
How to share between users (on different PCs) an excel file containing external references (VLOOKUPs on another file) and not having to edit the link each time we open the file (updated by the other user) ?
Actually, we are using a "dropbox" with several excel files located in different directories. So the relative path is the same at 2 levels but... excel looks like storing the full path... so the full path will be different depending on the user.
Is it possible to store the relative path ? Is there a turnaround ?
My config: Excel 2013, Windows 7.
Any help would be GREAT!
Thanks!!!
Yours, Joao.
