How to filter excel without affecting other users

Question

Hello Experts,

My team is using excel on web which is shared between a group of people. Since I am not comfortable using in it on the web, I select the option "Open in desktop app" and use the same file. But when I use filters or sorting, it affects the main sheet affecting all the other users. I know in the web based excel there is an option of street view. Is there same or similar option in desktop app?? I tried searching but didn't get any results.

Would appreciate an experts advice or help on this.

Thank you in advance. Looking forward to an earliest solution.

Answer 1

Hi hperacha,

We appreciate that you posted back and confirmed the information with us. We also appreciate that you spent your precious time doing those tests.

According to the screenshots you provided, you are not using the latest version of Semi-Annual Enterprise Channel, we have tested again on our side with the latest version of Semi-Annual Enterprise Channel, and we can see Sheet View, as shown below:

So we’d suggest you update your Excel to the latest version(2102 (Build 13801.20960)) to check if you can find this feature.

Please feel free to post back and let us know if it is help.

Best Regards,

Sukie

Answer 2

Hello Sukie,

I would need sometime to update Office. At the moment, don't need help but once I update and this don't work, i'll surely get back to you.

Thank you for all your help.

Take care,

Answer 3

Hi hperacha,

Thank you for your feedback again.

Since you mentioned that you need some time to update, if you have any updates, welcome to post back and share with us, we will also continue to try our best to help you.

Best regards,

Sukie