Forum Discussion
Excel-Macro to close the file if is in use by another user
Good Morning To avoid Onedrive synchronization errors, is there an effective way so that when entering the Excel file, if it is already open, a message appears that it will close and when pressing O...
Hello good morning, we are all using office 368 premium and Family right now.
In relation to having a password in the file, I don't think I need it, because everyone can access the file, there is no need for that kind of security.
The problem is that if a second user enters the file already open, Onedrive will give a sync error message and suggest having 2 files.
So I wanted excel not to let the file be used by more than 1 person. When the second user enters, the macro verifies that it is open and closes the file. I hope I'm explaining well the problem I want to solve. Thanks
In relation to having a password in the file, I don't think I need it, because everyone can access the file, there is no need for that kind of security.
The problem is that if a second user enters the file already open, Onedrive will give a sync error message and suggest having 2 files.
So I wanted excel not to let the file be used by more than 1 person. When the second user enters, the macro verifies that it is open and closes the file. I hope I'm explaining well the problem I want to solve. Thanks
Then this link should help you.
Collaborate on Excel workbooks at the same time with co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring.
To co-author in Excel for Windows desktops, you need to make sure certain things are set up before you start. After that, it just takes a few steps to co-author with other people.
Thank you for your patience and understanding
Nikolino
The solution is always simple. You just have to find it :).
(Alexander Solzhenitsyn)