SOLVED

Hide rows/columns in 365 shared Excel-file - local setting

%3CLINGO-SUB%20id%3D%22lingo-sub-1426156%22%20slang%3D%22en-US%22%3EHide%20rows%2Fcolumns%20in%20365%20shared%20Excel-file%20-%20local%20setting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426156%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20new%20share%20of%20365%2C%20most%20users%20use%20the%20auto-save%20functionality.%20This%20has%20an%20unwanted%20side-effect.%20When%20person%20A%20hides%20some%20rows%20or%20columns%2C%20all%20other%20users%20lose%20visibility%20on%20those%20rows%2Fcolumns%20as%20well.%20They%20need%20to%20see%20it%20and%20unhide.%20Person%20A%20hides%20again%2C%20and%20so%20on...%3C%2FP%3E%3CP%3EThe%20same%20goes%20for%20applying%20filters.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20function%20to%20make%20hiding%20rows%2Fcolumns%20or%20applying%20filters%20a%20local%20setting%3F%20It%20was%20possible%26nbsp%3Bin%20the%20old%20way%20of%20sharing%20Excel-files.%20But%20I%20don't%20find%20it%20in%20the%20new%20365-way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20support.%3C%2FP%3E%3CP%3EJonas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1426156%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1426177%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20rows%2Fcolumns%20in%20365%20shared%20Excel-file%20-%20local%20setting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1426177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F683256%22%20target%3D%22_blank%22%3E%40JonasVH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20files%20shared%20on%20Sharepoint%20%2F%20Onedrive%20each%20user%20may%20organize%20it's%20own%20Sheet%20View%20which%20allows%20to%20filter%20%2F%20sort%20data%20without%20affecting%20other%20users%20of%20the%20file.%20That%20is%20available%20for%20Excel%20Online%20and%20Excel%20for%20Win%20Desktop%20only%20Beta%20channel%20so%20far.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHiding%20will%20affect%20all%20users%2C%20that%20doesn't%20work%20with%20Sheet%20View.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

In the new share of 365, most users use the auto-save functionality. This has an unwanted side-effect. When person A hides some rows or columns, all other users lose visibility on those rows/columns as well. They need to see it and unhide. Person A hides again, and so on...

The same goes for applying filters.

 

Is there a function to make hiding rows/columns or applying filters a local setting? It was possible in the old way of sharing Excel-files. But I don't find it in the new 365-way.

 

Thanks for your support.

Jonas

3 Replies
Highlighted
Best Response confirmed by JonasVH (New Contributor)
Solution

@JonasVH 

For the files shared on Sharepoint / Onedrive each user may organize it's own Sheet View which allows to filter / sort data without affecting other users of the file. That is available for Excel Online and Excel for Win Desktop only Beta channel so far.

 

Hiding will affect all users, that doesn't work with Sheet View.

Highlighted

@Sergei Baklan 

Thanks for your answer. It's good that we will have a solution in the future.

I tried to find when this option will be rolled out to all users, but couldn't. Any idea when we will have this option available in the normal Excel?

Unfortunately, Excel online has little to no use for us, as the functionality is very limited.

Highlighted

@JonasVH 

I guess nobody knows, even MSFT, it depends on many things. I've seen nothing about licensing of that functionality - it could be available for all subscriptions or only for E3 and E5 or something else. Who knows.

Hope this summer we could expect for Current channel.