Allow autosave/co-authoring for password protected workbooks
When using co-authoring with Autosave in latest Excel desktop client, it fails if the workbook is password protected. Allow multiple users to edit a password protected workbook.
Thank you for taking the time to suggest and vote for this feature. We do not have plans to support coauthoring in password protected notebooks, but we are working to support coauthoring with protected documents in desktop clients. See here for more information: https://office365.uservoice.com/forums/928576-microsoft-information-protection-mip/suggestions/19696030-enable-co-authoring-of-protected-documents.
Pallavi H [MS Excel]
23 commentsComments are closed
This one specific drawback is preventing one client with over 1TB of Excel files from benefitting from co-authoring.
Same problem here. I could not understand why autosave is turned off for password protected files. For me this is not even about co-authoring, I just have some very sensitive information stored in 1 file, which I want to have password protected, as it is on my (business) OneDrive. You will say nobody can access my files on OneDrive, but I'm not so sure.
We have the same problem if the following conditions meet:
1. user have read permisson to the sharepoint folder "XY"
2. user have permission to edit the excel sheet located inside the sharepoint folder "XY"
3. excel sheet have workbook and/or sheet protection enabled (password)
If the user open the excel sheet, enter password, edit it, change something and try to save the following message appears: "Can't save There was a problem saving and AutoSave was disabled. Please Save As or close and reopen the file."
We created a subfolder inside sharepoint folder "XY",grant the user edit permission to this subfolder, saved the excel sheet there and the user was able to save changes.
Hopefully this workaround will help someone.
I get Upload Failed on password protected workbooks in SPO even though I know I'm the only one using the workbook
I would also appreciate this option because we need it for our time sheet in the company.
I would appreciate this option.
We have an Excel file in which Account Managers fill their requirements for the next week. At a certain point (Deadline) the file must be locked to be edited by the purchase department only. Sales may open the file for viewing.
If the file is password protected the old fashioned way (save copy - extra - common options) the Autosave works. Co-authoring is still disabled though.
Seems like a nice workaround but we experience a lot of Sync problems this way. Colleagues looking at data which is sometimes days old. They need to delete the file from their Office Upload Center cache to get access to the most recent version.
Rob Gilliam commented
Biggedst problem isn't "co-authoring", it's the inability of Excel to merge changes I've made on different computers when I've saved from one and re-opened on another.
Shaun Kilmartin commented
Please please please allow this! We have some password protected files so that SharePoint admins cannot see them but then Co-Authoring fails.
I get this error too. I am not co-authoring but I do edit my password protected Excel file from two different devices. I open my file from my work PC (W10) when I'm at work and later from my Macbook when i'm at home. The single file is stored on my personal onedrive. This looks like a bug. Im not happy to have to remove my password to resolve this issue as my IT dept could reset my work AD PW and then access my personal onedrive from my company laptop and then access my personal budget file. It is only me who access this file, i dont want to share it except between my differing devices.
A303 Guest, I respectfully disagree. Consider the case where a co-authored enabled document gets accidentally emailed to an unauthorized user. It happens. One might suggest, as you have, putting sensitive documents in a domain-protected folder, and then disallowing users to edit in local Excel, and then further disallowing users to save that document locally, and then FURTHER disallowing users to email documents with specified words included in them. But that seems to be an awful lot of checks-and-balances to impose and enforce when simply adding password security, as does Adobe with its PDFs, solves all of those problems. (And again, consider the powers of a SharePoint administrator.)
A303 Guest commented
To everyone finding this annoying: Surely password-protecting a document that you wish to share amongst a team or group of people goes against the entire idea of co-authoring?
To me, it makes sense that this wouldn't work by design default.
If I have a file that I want open for collaboration, I don't then want to lock it down with a password. Ensure it's in a domain where only the people who need to contribute can access it. That way, you can put other files there too, and provide a single point of access, not loads of documents with different passwords everyone has to remember.
Agree completely. Password protection is a must, ESPECIALLY when one considers the powers that a SharePoint administrator has.
Mark B commented
Has this issue not been resolved yet? This is really annoying on a file that has to be password protected. Mike Wells, just a quick tip for you. You can select Save As, but then select the original file and overwrite it, rather than having to save a copy and delete the original each time.
Same issue & COMPLETELY agree with Mike Wells. Please fix! We are working in real life, not your controlled environment, Microsoft.
Jonathan Willcox commented
This is a problem for me on a file that I regularly use and would love to see it addressed soon.
Mike Wells commented
This problem drives me absolutely mad! It is such a waste of time having to save a copy then delete the original and rename the copy every time. I use this spreadsheet several times a day and the loss of productivity is enormous Please take this seriously and come up with a fix. This problem was raised over a year and a half ago and is still an issue for many.
The issue is goes beyond co-authoring. Intermittently (often after you have spent quite some time entering data of course) it occurs when you save the Excel spreadsheet even when b) you are the only person who even tries to edit the file (absolutely guaranteed on this) and b) knows the password anyway.
co-authoring doesn't work with password protected file. If you disable password protection and try to use RMS / AIP (Azure Rights Management / Azure Information Protection) co-authoring doesn't work either.
There is currently no way to protect a file using co-authoring
We were able to get it fixed by taking off the password and turning it back on.
Mr C Roads commented
Yes please it is odd that one cannot use this facility for PW protected files.