Forum Discussion

Copper Contributor

Aug 16, 2018

Filtered data in Excel online are visible for all users

Hi all! Is it possible to see only my own filtered data in Excel Online? I mean when other users are working with the same book at that moment. At the moment, when someone filtered data - every one...

filter

Haytham Amairah

Silver Contributor

Sep 14, 2018

Hi Andrey,

Sorry, but it seems that the filter, in particular, can be excluded from the collaboration restrictions as this https://excel.uservoice.com/forums/274580-excel-online/suggestions/8192445-allow-for-personal-user-views-filters?tracking_code=b58146067ee2f09fd6605df37d0fe87b suggests.

Please vote to the idea as I did.

The good news is that the Excel team has recently updated the idea status to Planned.

Regards

2mambo
Copper Contributor
Nov 04, 2020
Haytham Amairah And the bad news is that it's still not in place.
- Antonio131285
  Copper Contributor
  Mar 20, 2021
  2mambo
  
  A workaround in excel sharepoint is "Sheet view" . Every user can select create his own sheet view to filter without this be visible to other user that are using default view or its own view.
Andrey Mukovnin
Copper Contributor
Sep 14, 2018
Hi Haytham! It's a really good news, thanks a lot! I just voted!

As for a topic, i solved the problem as follows: divided data into several sheets. Users see only their sheet and do not see if another user has selected another sheet.