I am currently working on a sheet that I want select people to have full access to, while everyone else without the password for the sheet cannot. I can do mediocre and overly complicated solutions with VBA and limiting visibility and whatnot, but I don't understand why I can't have multiple people edit a password protected workbook. If there is any solutions to this problem or reasons why it is caused, please let me know.
1 Answer
You are asking to share an Excel workbook which is protected by password.
Microsoft calls this feature collaboration or co-authoring, and this feature is available on recent-enough versions of Excel.
You will find more information in the following article:
-
When co-authoring a password protected workbook, it only allows one user at a time to edit. If another user tries to access it, it reads the following: "Someone has this workbook locked. [User] has locked this file for editing. This may happen if they're using a non-subscription version of Excel. Ask them to close the file or check it in." Both users are using a subscription version of excel. I am trying to allow both users to edit at the same time, while the workbook is password protected. Commented Feb 3 at 13:52
-
-
The only condition that hasn't been met is that AutoSave is disabled, and that is because the sheet is password encrypted, which is what I want. Is there a method around this? Commented Feb 3 at 14:40
-
Microsoft says that this is required for co-authoring to work, and if workarounds exist then they are unknown to me. You might perhaps be able to do that better with Google Docs, but I'm not a user of that. For questions on Google Docs, you should ask on webapps.stackexchange.com.– harrymcCommented Feb 3 at 15:20
-
If my answer was helpful, please consider marking it as accepted.– harrymcCommented Feb 3 at 15:21