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.