Co authoring in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1554141%22%20slang%3D%22en-US%22%3ECo%20authoring%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554141%22%20slang%3D%22en-US%22%3EWe%20share%20spreadsheets%20in%20our%20team%20and%20used%20to%20use%20the%20legacy%20sharing.%20This%20now%20seems%20to%20be%20causing%20problems%20but%20we%20cannot%20work%20out%20how%20to%20have%20multiple%20users%20editing%20not%20only%20with%20personal%20filters%20which%20I%20understand%20but%20hiding%20columns%20which%20each%20person%20doesn't%20want%20to%20see.%20Any%20ideas%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1554141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1554148%22%20slang%3D%22en-US%22%3ERe%3A%20Co%20authoring%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554148%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744047%22%20target%3D%22_blank%22%3E%40Christina_museum%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20Sheet%20View%20functionality%20it%20supports%20only%20separated%20sorting%20and%20filtering%2C%20not%20hiding.%20Not%20sure%20if%20workaround%20for%20the%20latest%20exists.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555800%22%20slang%3D%22en-US%22%3ERe%3A%20Co%20authoring%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555800%22%20slang%3D%22en-US%22%3E%3CP%3Emany%20thanks%20anyway%2C%20i%20will%20keep%20trying%20to%20think%20of%20a%20work%20around%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555866%22%20slang%3D%22en-US%22%3ERe%3A%20Co%20authoring%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555866%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744047%22%20target%3D%22_blank%22%3E%40Christina_museum%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAt%20least%20you%20may%20vote%20for%20this%20idea%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-for-the-web%2Fsuggestions%2F39398026-maintain-hidden-rows-columns-in-sheet-view-so-ot%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMaintain%20hidden%20rows%2Fcolumns%20in%20%22sheet%20view%22%20so%20other%20users%20are%20not%20affected%20by%20the%20change%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1556127%22%20slang%3D%22en-US%22%3ERe%3A%20Co%20authoring%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556127%22%20slang%3D%22en-US%22%3E%3CP%3Egood%20idea%20thanks%2C%20I'm%20very%20new%20to%20this%20%2C%20just%20joined%20to%20try%20to%20find%20some%20solution%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
We share spreadsheets in our team and used to use the legacy sharing. This now seems to be causing problems but we cannot work out how to have multiple users editing not only with personal filters which I understand but hiding columns which each person doesn't want to see. Any ideas?
4 Replies

@Christina_museum 

If you mean Sheet View functionality it supports only separated sorting and filtering, not hiding. Not sure if workaround for the latest exists.

many thanks anyway, i will keep trying to think of a work around@Sergei Baklan 

good idea thanks, I'm very new to this , just joined to try to find some solution@Sergei Baklan