Jan 18 2021 06:08 PM
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?
Jan 19 2021 07:19 AM
Jan 19 2021 08:57 AM
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?