Forum Discussion
Update Excel formulas between a path in local folder and owncloud in another computer
Map the same drive letter on both computers.
That’s the cleanest, no-macro, no-maintenance solution:
- Excel thinks it’s opening the same files.
- You can work seamlessly both locally and in OwnCloud.
- No need to rewrite formulas.
Example
On both computers, ensure this path works:
H:\Fold\Data\physics\summary\daily_summary.xlsx
On the OwnCloud computer, that’s just a mapped shortcut to:
C:\Users\fulanito\ownCloud\Shared\Data\physics\summary\daily_summary.xlsx
Then formulas like:
='H:\Fold\Data\physics\2025\[data_2025.xlsx]Horario'!AV1419
will update perfectly from either machine.
My answers are voluntary and without guarantee!
Hope this will help you.
Wow. That was a very correct and simple solution. Thank you. If the fold is a C: I only have to create the "fake" fold of the original formula and then use
mklink /J "C:\Fold\Data\physics\" "C:\Users\fulanito\ownCloud\Shared\Data\physics\"
So they always will be linked and excel will find C:\Fold
But in this case is not a C partition, is H: so I have to use an empty fold like
C:\testH and then subst H: "C:\testH"
Because subst have to be used every time I iniate session I created a little script that initiate every time I turn on my computer. So, problem solved. Thank you very much for your simple answer.
Now excel thinks H: exists in the mounted computer doesn't have to look for routes.