Forum Discussion

swaters504's avatar
swaters504
Copper Contributor
Jan 19, 2021

Multi-User Excel Userform

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?  

excel
Macros and VBA

3 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 19, 2021
    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)
    • swaters504's avatar
      swaters504
      Copper Contributor
      Jan 19, 2021

      JKPieterse 

       

      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? 

Resources