Hi everyone,
I'm working on a big project on Excel where I will have about 20 users sharing the same file where they will be filling out a form in which everything gets compiled into 1 data base. The big issue I am having now is if for example 2 users have the same file opened and one submits his entry, the other will get into a conflict with his entry. I am trying to bypass this by accepting all the others data stay, and the 2nd user's entry to go on the next line. I've tried many different things and the best solution I found is updating the Shared settings in Excel to have the file refresh every 5 minutes to see other user changes. My problem is that I need this to be at least 1 minute or less or find a VBA command that will force through the refresh of other changes. Please help!
I'm working on a big project on Excel where I will have about 20 users sharing the same file where they will be filling out a form in which everything gets compiled into 1 data base. The big issue I am having now is if for example 2 users have the same file opened and one submits his entry, the other will get into a conflict with his entry. I am trying to bypass this by accepting all the others data stay, and the 2nd user's entry to go on the next line. I've tried many different things and the best solution I found is updating the Shared settings in Excel to have the file refresh every 5 minutes to see other user changes. My problem is that I need this to be at least 1 minute or less or find a VBA command that will force through the refresh of other changes. Please help!
