Let users edit Excel at the same time with their own filter update and one's change won't affect others
when multiple users making changes in Excel onine, a user's operation will affect others which means that users can hardly really edit file at the same time, is there any way to solve this issure?
Requirement: Let users edit Excel at the same time with their own filter update and one's change won't affect others.
Matt Schultz commented
An idea could be a view lock and allow the individual user to filters yet allowing others to add data and it to come through. When you unlock, the view returns to the original state but new data is added or edited.
THIS WOULD BE AWESOME!
We have multiple people looking at the same sheet online and editing data in one column that updates the progress of an issue. The data that each person needs in a different column but they have to see everyone else's data and sort through it to get to their own.