Home

Filtered data in Excel online are visible for all users

%3CLINGO-SUB%20id%3D%22lingo-sub-229344%22%20slang%3D%22en-US%22%3EFiltered%20data%20in%20Excel%20online%20are%20visible%20for%20all%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-229344%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIs%20it%20possible%20to%20see%20only%20my%20own%20filtered%20data%20in%20Excel%20Online%3F%3C%2FSPAN%3E%20I%20mean%20when%20other%20users%20are%20working%20with%20the%20same%20book%20at%20that%20moment.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EAt%20the%20moment%2C%20when%20someone%20filtered%20data%20-%20every%20one%20who%20edit%20the%20same%20document%20will%20see%20the%20same%20filters.%20I%20would%20like%20to%20know%20is%20it%20possible%20to%20avoid%20this.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EThanks%20a%20lot%20for%20yours%20answers!%20Have%20a%20nice%20day!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-229344%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFilter%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252638%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20data%20in%20Excel%20online%20are%20visible%20for%20all%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252638%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Haytham!%20It's%20a%20really%20good%20news%2C%20thanks%20a%20lot!%20I%20just%20voted!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20for%20a%20topic%2C%20i%20solved%20the%20problem%20as%20follows%3A%20divided%20data%20into%20several%20sheets.%20Users%20see%20only%20their%20sheet%20and%20%3CSPAN%20class%3D%22%22%3Edo%20not%20see%20if%20another%20user%20has%20selected%20another%20sheet.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-252610%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20data%20in%20Excel%20online%20are%20visible%20for%20all%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-252610%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Andrey%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3ESorry%2C%20but%20it%20seems%20that%20the%20filter%2C%20in%20particular%2C%20can%20be%20excluded%20from%20the%20collaboration%20restrictions%20as%20this%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-online%2Fsuggestions%2F8192445-allow-for-personal-user-views-filters%3Ftracking_code%3Db58146067ee2f09fd6605df37d0fe87b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eidea%3C%2FA%3E%20suggests.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F49772iA3AFFC80AA68F773%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Personal%20User%20Filters.png%22%20title%3D%22Personal%20User%20Filters.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EPlease%20vote%20to%20the%20idea%20as%20I%20did.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EThe%20good%20news%20is%20that%20the%20Excel%20team%20has%20recently%20updated%20the%20idea%20status%20to%20%3CSTRONG%3EPlanned%3C%2FSTRONG%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3ERegards%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-233695%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20data%20in%20Excel%20online%20are%20visible%20for%20all%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-233695%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Philip%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20including%20Excel%20for%20Desktop%20as%20well%20and%20even%20Excel%20for%20Android%20and%20iOS.%3C%2FP%3E%3CP%3EPlease%20read%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FCollaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Earticle%3C%2FA%3E%20for%20more%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-229431%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20data%20in%20Excel%20online%20are%20visible%20for%20all%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-229431%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20sure%20this%20worked%20on%20'shared'%20workbooks%20though%3F%20It's%20only%20the%20online%20version%20that%20doesn't%20seem%20to%20be%20able%20to%20do%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-229419%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20data%20in%20Excel%20online%20are%20visible%20for%20all%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-229419%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Andrey%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20not%20possible%2C%20and%20I%20don't%20think%20it%20will%20ever%20be%26nbsp%3Bpossible!%3C%2FP%3E%3CP%3EBecause%20the%20idea%20of%20collaboration%20and%20co-authoring%20%3CSPAN%20class%3D%22%22%3Erequires%20synchronizing%20changes%20between%20users%20who%20are%20working%20on%20the%20same%20Excel%20workbook.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EYou%20cannot%20prevent%20other%20users%20from%20seeing%20your%20changes%20in%20the%20same%20workbook%20you're%20working%20on.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3EBest%20Regards%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-229366%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20data%20in%20Excel%20online%20are%20visible%20for%20all%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-229366%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20what%20you%20mean%2C%20it%20seems%20odd%20that%20it%20doesn't%20work%20that%20way%2C%20but%20no%20there%20isn't%20a%20way%20to%20have%20private%20filters.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847933%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20data%20in%20Excel%20online%20are%20visible%20for%20all%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EIn%20fact%2C%20it's%20possible.%20Due%20to%20the%20fact%20that%20this%20function%20has%20been%20in%20Google%20Sheets%20since%202017.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Andrey Mukovnin
New Contributor

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 who edit the same document will see the same filters. I would like to know is it possible to avoid this.

Thanks a lot for yours answers! Have a nice day!

7 Replies

I know what you mean, it seems odd that it doesn't work that way, but no there isn't a way to have private filters.

Hi Andrey,

 

This is not possible, and I don't think it will ever be possible!

Because the idea of collaboration and co-authoring requires synchronizing changes between users who are working on the same Excel workbook.

You cannot prevent other users from seeing your changes in the same workbook you're working on.

 

Best Regards

I'm sure this worked on 'shared' workbooks though? It's only the online version that doesn't seem to be able to do it.

Highlighted

Hi Philip,

 

This is including Excel for Desktop as well and even Excel for Android and iOS.

Please read this article for more information.

 

Regards

Hi Andrey,

 

Sorry, but it seems that the filter, in particular, can be excluded from the collaboration restrictions as this idea suggests.

 

Personal User Filters.png

 

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

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.

@Haytham Amairah 
In fact, it's possible. Due to the fact that this function has been in Google Sheets since 2017.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies