Sharing a password protected workbook on sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-2403315%22%20slang%3D%22en-US%22%3ESharing%20a%20password%20protected%20workbook%20on%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2403315%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20password%20protected%20workbook%20that%20is%20currently%20on%20our%20company%20SharePoint%20site.%20Is%20there%20anyway%20to%20allow%20more%20than%20one%20user%20to%20access%20and%20edit%20this%20at%20the%20same%20time.%20At%20the%20moment%20once%20the%20first%20user%20opens%20the%20workbook%20the%20rest%20will%20only%20have%20read%20only%20access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2403315%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2403426%22%20slang%3D%22en-US%22%3ERe%3A%20Sharing%20a%20password%20protected%20workbook%20on%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2403426%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1057714%22%20target%3D%22_blank%22%3E%40jlowhang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcollaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CFONT%20size%3D%224%22%3ECollaborate%20on%20Excel%20workbooks%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%3CFONT%20size%3D%224%22%3EYou%20and%20your%20colleagues%20can%20open%20and%20work%20on%20the%20same%20Excel%20workbook.%20This%20is%20called%20co-authoring.%20When%20you%20co-author%2C%20you%20can%20see%20each%20other's%20changes%20quickly%E2%80%94in%20a%20matter%20of%20seconds.%20And%20with%20certain%20versions%20of%20Excel%2C%20you'll%20see%20other%20people's%20selections%20in%20different%20colors.%20If%20you're%20using%20a%20version%20of%20Excel%20that%20supports%20co-authoring%2C%20you%20can%20select%20%3CSTRONG%3EShare%3C%2FSTRONG%3E%20in%20the%20upper-right%20corner%2C%20type%20email%20addresses%2C%20and%20then%20choose%20a%20cloud%20location.%20But%20if%20you%20need%20more%20details%2C%20like%20which%20versions%20are%20supported%20and%20where%20the%20file%20can%20be%20stored%2C%20this%20article%20will%20walk%20you%20through%20the%20process.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fabout-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAbout%20the%20shared%20workbook%20feature%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EImportant%3A%3C%2FSTRONG%3E%26nbsp%3B%22Shared%20Workbooks%22%20is%20an%20older%20feature%20that%20allows%20you%20to%20collaborate%20on%20a%20workbook%20with%20multiple%20people.%20This%20feature%20has%20many%20limitations%2C%20and%20has%20been%20replaced%20by%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcollaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eco-authoring%3C%2FA%3E.%20Excel%20co-authoring%20is%20available%20in%20Microsoft%20365%20Apps%20Excel%20desktop%20client%20and%20Excel%20for%20the%20Web%20for%20%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%2F%3Flinkid%3D2143729%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMicrosoft%20365%20subscribers%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHope%20I%20could%20help%20you%20with%20this%20information.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have a password protected workbook that is currently on our company SharePoint site. Is there anyway to allow more than one user to access and edit this at the same time. At the moment once the first user opens the workbook the rest will only have read only access.

 

2 Replies

@jlowhang 

 

Collaborate on Excel workbooks

You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of seconds. And with certain versions of Excel, you'll see other people's selections in different colors. If you're using a version of Excel that supports co-authoring, you can select Share in the upper-right corner, type email addresses, and then choose a cloud location. But if you need more details, like which versions are supported and where the file can be stored, this article will walk you through the process.

 

About the shared workbook feature

Important: "Shared Workbooks" is an older feature that allows you to collaborate on a workbook with multiple people. This feature has many limitations, and has been replaced by co-authoring. Excel co-authoring is available in Microsoft 365 Apps Excel desktop client and Excel for the Web for Microsoft 365 subscribers.

 

Hope I could help you with this information.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

 

Thankyou, I'm looking into co-authoring as having tried sharing the workbook it brings up a number of things I can't change in the work book to do with the macros etc. But I'll test this tomorrow when my colleague is back and see how it works.