SOLVED

Sheet View isn't working at all in my shared excel document - changes don't revert in Default view

%3CLINGO-SUB%20id%3D%22lingo-sub-1534681%22%20slang%3D%22en-US%22%3ESheet%20View%20isn't%20working%20at%20all%20in%20my%20shared%20excel%20document%20-%20changes%20don't%20revert%20in%20Default%20view%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534681%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20want%20to%20see%20if%20it's%20just%20me%20or%20if%20anyone%20else%20is%20experiencing%20this%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20currently%20working%20on%20a%20document%20shared%20with%20me%20and%20when%20I%20try%20to%20use%20the%20new%20Sheet%20View%20feature%20to%20hide%20rows%20applicable%20to%20me%20it%20seems%20to%20affect%20the%20whole%20document%20for%20everyone%20else.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20seems%20to%20be%20for%20both%20the%20web%20and%20desktop%20(Mac)%20platforms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20I'm%20doing%20to%20replicate%20my%20issue%20(on%20web)%3A%3C%2FP%3E%3CP%3EView%20%26gt%3B%20New%20%26gt%3B%20Keep%20(Default%20'View1'%20is%20saved)%20%26gt%3B%20Hide%20rows%20in%20document%20%26gt%3B%20Exit%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20I%20have%20clicked%20on%20Exit%20or%20even%20click%20on%20the%20'Default'%20view%20the%20rows%20are%20still%20hidden%20and%20unfortunately%20this%20is%20also%20applied%20for%20everyone%20else%20viewing%20the%20document%20at%20the%20same%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20also%20tried%20making%20a%20new%20view%20with%20no%20changes%20and%20after%20making%20changes%20in%20a%20different%20view%20it%20would%20also%20apply%20to%20the%20new%20untouched%20one%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20else%20I've%20seen%20is%20that%20a%20dialogue%20box%20shows%20up%20when%20you%20make%20changes%20to%20the%20view%20without%20touching%20Sheet%20View%20which%20allows%20you%20do%20the%20same%20thing%20as%20above%20but%20this%20doesn't%20happen%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20strange%20that%20this%20feature%20is%20now%20available%20for%20my%20organisation%20yet%20it%20doesn't%20function%20at%20all.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1534681%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1534984%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20isn't%20working%20at%20all%20in%20my%20shared%20excel%20document%20-%20changes%20don't%20revert%20in%20Default%20vi%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F734509%22%20target%3D%22_blank%22%3E%40Felix1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESheet%20view%20works%20only%20with%20filtering%20and%20sorting%2C%20is%20that%20your%20case%3F%20All%20other%20operations%20don't%20affect%20sheet%20view%2C%20includes%20hiding%2Funhiding%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1535018%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20isn't%20working%20at%20all%20in%20my%20shared%20excel%20document%20-%20changes%20don't%20revert%20in%20Default%20vi%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535018%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3EWe'll%20I%20feel%20like%20an%20idiot%20now.%20Thanks%20for%20pointing%20that%20out!%20In%20that%20case%20I%20wish%20they%20would've%20added%20that%20as%20something%20we%20could%20change%20too%20because%20that%20would%20be%20immensely%20useful.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone,

 

Just want to see if it's just me or if anyone else is experiencing this issue.

 

I'm currently working on a document shared with me and when I try to use the new Sheet View feature to hide rows applicable to me it seems to affect the whole document for everyone else.

 

This seems to be for both the web and desktop (Mac) platforms.

 

This is what I'm doing to replicate my issue (on web):

View > New > Keep (Default 'View1' is saved) > Hide rows in document > Exit

 

Once I have clicked on Exit or even click on the 'Default' view the rows are still hidden and unfortunately this is also applied for everyone else viewing the document at the same time.

 

I have also tried making a new view with no changes and after making changes in a different view it would also apply to the new untouched one as well.

 

Something else I've seen is that a dialogue box shows up when you make changes to the view without touching Sheet View which allows you do the same thing as above but this doesn't happen for me.

 

It seems strange that this feature is now available for my organisation yet it doesn't function at all.

3 Replies
best response confirmed by Felix1 (New Contributor)
Solution

@Felix1 

Sheet view works only with filtering and sorting, is that your case? All other operations don't affect sheet view, includes hiding/unhiding

@Sergei BaklanWe'll I feel like an idiot now. Thanks for pointing that out! In that case I wish they would've added that as something we could change too because that would be immensely useful.

wow, I had the same 'problem': this seemed so straightforward from a user-perspective that columns/row hidden status should be saved with the sheet-view, that I hadn't even thought of that it -only- saves the sorting and filtering #mindblown