Excel Online - default view and filters

%3CLINGO-SUB%20id%3D%22lingo-sub-3003184%22%20slang%3D%22en-US%22%3EExcel%20Online%20-%20default%20view%20and%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003184%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20file%20using%20Excel%20online%20and%20for%20some%20reason%2C%20every%20time%20everyone%20opens%20the%20file%2C%20the%20default%20view%20is%20set%20to%20a%20certain%20employees%20filtered%20view.%26nbsp%3B%20I%20tried%20to%20edit%20the%20default%20view%20to%20get%20rid%20of%20the%20filters%20but%20that%20does%20not%20look%20possible%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3003184%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3010775%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20-%20default%20view%20and%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010775%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325149%22%20target%3D%22_blank%22%3E%40Bryan123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20please%20always%20add%20specific%20information%20about%20your%20Excel%20version%20and%20operating%20system%20to%20your%20concerns.%20As%20well%20as%2C%20if%20possible%20or%20necessary%2C%20a%20file%20(without%20sensitive%20data).%20Information%20on%20where%20the%20file%20is%2C%20such%20as%20OnDrive%20or%20Sharepoint%2C%20is%20of%20advantage.%20In%20this%20way%2C%20you%20will%20come%20up%20with%20a%20proposed%20solution%20much%20faster%20and%20more%20precisely.%20This%20also%20makes%20it%20much%20easier%20for%20the%20helpers%20to%20provide%20the%20help%20that%20they%20would%20like%20to%20offer%20you.%20It%20helps%20both%20%3A).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20link%20with%20information%20on%20how%20you%20can%20quickly%20find%20a%20solution%20that%20is%20most%20suitable%20for%20you.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20welcome%20you%20to%20this%20forum%20with%20a%20new%20question%20also%20in%20the%20future.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

We have a file using Excel online and for some reason, every time everyone opens the file, the default view is set to a certain employees filtered view.  I tried to edit the default view to get rid of the filters but that does not look possible

 

Any ideas?

2 Replies

@Bryan123 

With your permission, if I can recommend you, please always add specific information about your Excel version and operating system to your concerns. As well as, if possible or necessary, a file (without sensitive data). Information on where the file is, such as OnDrive or Sharepoint, is of advantage. In this way, you will come up with a proposed solution much faster and more precisely. This also makes it much easier for the helpers to provide the help that they would like to offer you. It helps both :).

 

Here is a link with information on how you can quickly find a solution that is most suitable for you.

Welcome to your Excel discussion space!

 

 

Thank you for your understanding

 

I would be happy to welcome you to this forum with a new question also in the future.

 

NikolinoDE

I know I don't know anything (Socrates)

I am having a problem, when using Excel in a formula, the results = SPILL