Multi-User Excel Userform

%3CLINGO-SUB%20id%3D%22lingo-sub-2072822%22%20slang%3D%22en-US%22%3EMulti-User%20Excel%20Userform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2072822%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone!%26nbsp%3B%20I%20am%20a%20VBA%20newbie%2C%20so%20please%20forgive%20if%20this%20is%20an%20obvious%20question.%26nbsp%3B%20I%20have%20developed%20an%20excel%20userform%20that%20will%20allow%20the%20user%20to%20enter%2C%20edit%20and%20search%20entries.%26nbsp%3B%20My%20goal%20is%20to%20upload%20it%20to%20SharePoint%20so%20multiple%20colleagues%20can%20enter%20data%20at%20the%20same%20time.%20Currently%20if%20one%20person%20is%20in%20the%20file%2C%20anyone%20else%20that%20tries%20to%20access%20receives%20an%20error%20message.%26nbsp%3B%20Any%20suggestions%20on%20how%20to%20get%20this%20to%20work%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2072822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2074584%22%20slang%3D%22en-US%22%3ERe%3A%20Multi-User%20Excel%20Userform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2074584%22%20slang%3D%22en-US%22%3EIf%20everyone%20is%20on%20Microsoft365%2C%20this%20should%20work.%20If%20you%20open%20the%20file%20in%20question%2C%20is%20the%20%22Save%22%20switch%20turned%20on%20(top-left%20corner%20of%20the%20Excel%20window)%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone!  I am a VBA newbie, so please forgive if this is an obvious question.  I have developed an excel userform that will allow the user to enter, edit and search entries.  My goal is to upload it to SharePoint so multiple colleagues can enter data at the same time. Currently if one person is in the file, anyone else that tries to access receives an error message.  Any suggestions on how to get this to work?  

3 Replies
If everyone is on Microsoft365, this should work. If you open the file in question, is the "Save" switch turned on (top-left corner of the Excel window)

@Jan Karel Pieterse 

 

Hi Jan - thank you for responding.  I have instructed everyone to turn the autosave feature off, but in testing this morning, the changes I make in the file do not appear in the other open versions and vice versa.  The others just get a message saying their changes could not be saved and given the option to save an additional copy.  

 

Do you think it may work better if we use OneDrive instead of SharePoint? 

The switch should no on, not off