Hi,
I am encountering the following issue while running Excel macro code in one drive “Can’t save your Changes. We are sorry, we cannot merge your changes with the latest changes made by another user.” How do I prevent this randomly happening. I am using Excel Application Scope and using hot keys inside it to execute macro code and closing workbook after that. The above gets repeated for each of the macro code modules. Thak you,
It is not advised to run macros or modify files directly on a one drive folder…
Instead copy the file to a local folder and perform the modifications and then copy back the file to one drive location at the end of changes…else due to one drive auto sync featurs the files goes into locked
Also coming to running macro …instead of using send hotkeys you can use invoke macro activity…where if you give the macro name then corresponding macro would be executed
Hope this helps
Cheers
Hi @A_Learner ,
If we try to save files in OneDrive sometimes it always open as “Read Only mode”, so if possible keep in any local folder and use “Run Macro” activity.
Thanks