Excel share option
My team members regularly need to work on the same excel file and we are using office 365 in our organization and what I noticed is that, If I share the work in share option using one drive. They couldn't able to apply filters to their allocation of work even after they use desktop Excel app. If one team member applies the filter, it was reflecting to other team members as well. Which is not helping the purpose of 'Share' option in Excel.
Can someone fix this issue? Thank you!