Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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.
Thanks!

176 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Bill Jelen shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded  · 

    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 we do recognize the impact not having this ability has on your coauthoring experience. Stay tuned for more.
    Scott (Microsoft Excel PM)

    19 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base