Filtering Needs to Work in Co-Authoring
Say that several people are editing the same workbook. If Tom filters to show only his records, then the other people will only see Tom's records. We need to be able to have each person apply a different filter and see only their records.
Note that it is fine to require that the workbook can not have SUBTOTAL or AGGREGATE functions in order for independent filtering to work. If you allow these functions, then everyone will have different calculation results which would be problematic.
It is more important to us to be able to have each person apply a local filter than to have the rare AGGREGATE function work correctly.
Hello Everyone. We agree with you! The experience you’ve captured here is at the top of our list to address with a future coauthoring feature. I can’t share a timeline for when this will be delivered but wanted to let you know that it’s being planned now and we recognize the impact not having this ability has on your coauthoring experience. Stay tuned for more.
Scott (Microsoft Excel PM)
I really cant understand why this has not been done yet!!
If your using the now (legacy) shared workbook you can do this....move to the all new singing and dancing co-authoring and the filter situation is a mess!