Have a question about multiple people working in a single big Excel file. How do I stay in the same cell when someone else deletes entire rows?
Okay so I'm hoping that someone can help me out here. A month ago I started a new job where there's quite a bit of data in a single big Excel file, with multiple people working on it together at times. My issue is that there's one person that will sometimes delete rows because the data is no longer needed. That then causes issues when I'm for example putting in data in cell E625, the data will then move to either cell E624 or E626 depending on where the deleted row is, and it will actually replace the data that was already there. How can I ensure that I stay in cell E625? Because up till now I've noticed it every time but I worry that some data might unintentionally get lost/replaced because of this when I don't notice my data being entered into the wrong cell.