Forum Discussion
Kattzu
Jan 31, 2024Copper Contributor
Multiple users editing at once.
Hello and thank you for reading,
My job requires us to use Excel sheets to input data and I was wondering if there is a way to make it so that whilst someone is inputting data into a singular cell/column it could lock that single cell/column to be edited only by that single user.
We currently use 1 Excel sheet for about 40 people, when people input data there is a delay between the inputted data showing up on the excel sheet for all other users so we are running into a problem where someone will input data into one cell and someone else will not get the updated sheet until after they have tried to input new data resulting in having to show all data changes to each cell constantly which is a pain. So I was wondering if it’s possible to lock the entire column/cell to only allow that one person who clicked it first to input the data and if someone else needs to input data they can do it in another cell/column below the other one.
Not sure if I’m making sense but anyway any answers would be very appreciated! Thanks again.
3 Replies
Sort By