Multiple Users

[Rose_Owen]

Hello Ya'll,

My question is if you are using Excel as a data entry form is there any way to make it so multiple users can get into the form at the same time. Right now when one person is in the form using it, it is locked for editing to everyone else. Thanks for your help.

Rose

 

[Jonmo1]

You can use workbook sharing. Tools - Share Workbook

But honestly, you'd be far better off using ACCESS for multi user data entry. Then you can make a master excel sheet to extract that data.

 

[Rose_Owen]

Thank you for your help. That worked.

I would love to use Access because I have a lot more experience with that, but this is for work and they don't use Access.