Allow a site owner to kick a user out of a file opened in Excel Online
If you have multiple people co-authoring in Excel Online, there are times when you need to open the file in Excel - typically for advanced formatting, etc. If someone has accidentally left the file open in their browser, there is no way to force them out and keeps the file locked. Although not always intentional, it can create a major headache by not being able to simply kick/close out that particular user from editing.
Thank you for the feedback! Co-authoring between Web, Windows, and Mac is supported in current versions of Excel.
The request/fix is NOT COMPLETED. Allow document owners to close members out of the file!!!!!!
This has not been Completed! Users are still able to leave their browser open and lock an Excel Online workbooks. Please consider the OP's request and allow site owners to kick users out of Excel Online workbooks so that the excel file can be opened and edited on the Desktop.
This is not addressed. If I own the Excel file, and someone leaves it open Online and then goes to a meeting, or dinner, or to sleep, I absolutely need to the ability to kick them out. This is not co-authoring.
anyone has an answer to this yet?
How do we get this re-opened? This is not fixed / completed. The ask was not to allow for co-authoring nor does co-authoring capability address the need ; cause, remember, ya'll at MS haven't figured out how to allow for co-authoring, regardless if users are editing in both the app and online!
Site Admins/Owners still need the ability to "kick someone out of edit mode".
Colin Campbell commented
@ Excel Team [MSFT], this request IS NOT "completed"!
It makes me wonder if your account is even run by a human, because the response you've given, "Co-authoring between Web, Windows, and Mac is supported in current versions of Excel." sounds like a bot wrote it. It does not address the request at hand in the slightest.
We're not looking to "co-author", we've already had that functionality for a long time, OBVIOUSLY.
We're looking to be able to kick users out of a file so that we can make changes that are only possible when a single user has the file open.
This isn't hard, and it's not hard to respond to these requests appropriately. We've been asking for this for FIVE YEARS now... what gives?
escalating this to Satya Nadella to get approval for 1 hour of dev time to make this happen. so easy to code............
co-authoring doesn't work like you wish it did. Please fix this already. When I try to edit online when someone has left it open in their browser, it won't let me copy/paste. When I open in desktop and edit I get an irresolvable sync error and the only solution that works is saving a local copy, which defeats the point. This is not a functional collaborative tool.
Yes, I concur with all other comments in this thread, same issue, someone left connected to the file, and no way to kick them out, which eliminates my ability to edit the file (because no offense, but desktop app has about 1000x the abilities of Excel Online) :(
There are so many things that you cannot do while someone else has a file open, even if there is "co-authoring". A coworker left her computer in sleep mode and is on vacation for a full week. During this week, we can't do many of the things we need to do. There should be an executive admin function to boot people from the file for maintenance.
I found a way to kick the person out. If you have versioning turned on, find the last version the person updated and delete that version. This worked for me.
Please make this easy, it is so hatefull you cannot kick somebody out a file they forget to close en decide to go for dinner... please.
What answer is this? It does not address the problem stated. One of my file, as owner, is locked by a dummy user. How can we kick the dummy user out and start modifying the file again?
Yuriy Eduardovich Tereshchenko commented
@Kris, I suggest you are doing something wrong. There is option to open file in excel desktop app from teams, from one drive, from sharepoint etc. There is always the button "open in desktop app". And work in the desktop app being online! The only thing is that you need to have excel 365 desktop app installed. Not excel 2016, and preferably not even 2019. Because they support this feature only partly. But since you are using modern cloud-based collaboration tools like Teams, you probably have all the 365 office subscription and this is the app you have. So you can do anything, even move to other folders and rename the file - all the users will still be able to work with your file and you won't need to kick them out. And if for some reason you want still to kick people from file - you can disable their access anytime. The exact way to do this depends on what type of access you gave initially, but it all goes under the settings section "manage access".
I have had more headaches and issues using Teams. An admin or owner of a Team should have the ability to kick someone out of a document or at least temporarily lock it down for editing. We're using it for our nurses to indicate what they want their schedule to be because Kronos won't work for our particular situation. I have NO choice but to download a copy to my client Excel since the Teams and online version lack several features that we NEED in order to make this schedule effective. I'm unable to upload with the same name because someone has had this spreadsheet open since Saturday --- it's now Wednesday. I have even had multiple instances where Teams says that I have it open and can't rewrite when I clearly do not. How do I know I don't? Because I've closed and completely rebooted to ensure I didn't have it still open. Co-authoring is a great idea but there are so many things that cause work around and extra work just to make the co-authoring work.
Basically this co-authoring feature required Microsoft Office 365 Pro Plus which you can download portal.office.com
Gina Erwin commented
ADMIN: I'm generally a "tecnotard" and really don't know a whole lot when it comes to computer programs, but I just spent about 20 minutes reading thru 2 years of comments on this issue alone and the question still remains...HAS ANYONE FOUND A WAY TO UNLOCK A FILE THAT SOMEONE ELSE HAS LOCKED FOR EDITING?
Your response dated April 8,2020 that co-authoring between web, windows and mac is supported doesn't really seem to explain to me, anyway, HOW that can be accomplished. Co-authoring would be FANTASTIC!! Simply because, if we do make our updates on the "desktop app," how can we be sure that those changes migrate to the on-line file? Or did we just create a second "editable" file that will NEVER be updated again online? And when you have a team of 45 persons who are supposed to be using the same standardized documents that have now been corrupted and saved who knows how many times over, what the heck do we do now! AND our facility contact sheet is STILL LOCKED UP!!!!
Some instruction on Co-authoring and how to release a locked document or at least direction to a link for the instructions would be most helpful.
I would apologize for the rant, but I work in healthcare and I'm a bit frazzled, as I'm sure most of you are as well. With that said, please be safe and take the precautions seriously. Nothing is more important than our loved ones.
How is this not already a basic feature baked into onedrive?
Greg Simonis commented
Very good point Matt. I will stick to the topic at hand.
Anyone found a way to UNLOCK a file that someone else has LOCKED FOR EDITING?
Matthew Kostak commented
Everyone on this thread - we are almost all aware of O365 capabilities in the desktop and browser. There are many reasons people can get locked out of a file. Upload Center cache corruption, "check out", someone's computer crashing during a file save. Many things can cause a user to lock a file, EVEN YOU can lock out a file unintentionally. What this post is asking is for us to be able to administratively perform a command in SharePoint/OneDrive/Teams, wherever the file is stored, and "unlock" or "kick" that person out of the file. That is the ask, not to just be able to have multiple people edit in different browsers.