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.
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.
