Sheet View

%3CLINGO-SUB%20id%3D%22lingo-sub-1302384%22%20slang%3D%22en-US%22%3ESheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302384%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20you%20hide%20columns%20without%20affecting%20other%20user's%20views%20on%20a%20shared%20Excel%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1302384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1332085%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1332085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616180%22%20target%3D%22_blank%22%3E%40Emmylou66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20question%20I%20too%20have...I%20posted%20a%20thread%20but%20have%20yet%20to%20receive%20any%20responses...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1332307%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1332307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626168%22%20target%3D%22_blank%22%3E%40Amanda_Fasano%3C%2FA%3E%26nbsp%3B%20Since%20this%20question%20was%20asked%20I%20have%20MORE.%20There%20are%20no%20%22tracking%22%20features%20on%20the%20online%20shared%20excel%20workbooks.%20Shared!%20No%20way%20to%20see%20who%20or%20when%20changes%20are%20being%20made.%20That%20is%20mind%20blowing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1332318%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1332318%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616180%22%20target%3D%22_blank%22%3E%40Emmylou66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20referring%20to%20the%20legacy%20feature%20%22Shared%20Workbook%22%3F%26nbsp%3B%20I%20can't%20recommend%20using%20this%20and%20Microsoft%20encourages%20using%20365's%20co-authoring.%26nbsp%3B%20The%20old%20Shared%20Workbook%20feature%20is%20not%20the%20most%20stable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1332334%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1332334%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%3E%40Patrick2788%3C%2FA%3E%26nbsp%3Bwe%20are%20using%20the%20shared%20excel%20sheet%20through%20Office%20365.%20What%20is%20%22%3CSPAN%3E365's%20co-authoring%22%3F%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1332411%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1332411%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616180%22%20target%3D%22_blank%22%3E%40Emmylou66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECo-authoring%20is%20available%20when%20the%20workbook%20is%20stored%20on%20OneDrive%20or%20SharePoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FDocument-collaboration-and-co-authoring-EE1509B4-1F6E-401E-B04A-782D26F564A4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FDocument-collaboration-and-co-authoring-EE1509B4-1F6E-401E-B04A-782D26F564A4%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1332621%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1332621%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%3E%40Patrick2788%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20this%20information.%20I%20appreciate%20it.%20Going%20to%20read%20up%20and%20see%20if%20this%20will%20work.%20We%20currently%20have%20close%20to%2012%20people%20working%20out%20of%20one%20shared%20excel%20database.%20It's%20been%20a%20nightmare%2C%20honestly.%20You%20cannot%20hide%20a%20column%20without%20messing%20up%20someone%20else's%20view%2C%20etc.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1332850%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1332850%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616180%22%20target%3D%22_blank%22%3E%40Emmylou66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20it's%20your%20best%20option%20and%20you'd%20have%20access%20to%20a%20version%20history%20of%20the%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408685%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408685%22%20slang%3D%22en-US%22%3E%3CP%3EI%20agree%20with%20Patrick%2C%20the%20statement%20%22%3CSPAN%3EYou%20cannot%20hide%20a%20column%20without%20messing%20up%20someone%20else's%20view%3C%2FSPAN%3E%22%20ring%20true%2C%20from%20what%20I%20can%20gather%20thus%20far.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20summary%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhen%20you%20%3C%2FSPAN%3E%3CFONT%3Ehide%20(or%20unhide)%20%3CU%3E%3CSTRONG%3EROWS%3C%2FSTRONG%3E%20%3C%2FU%3Ein%20ANY%20view%20(filter)%2C%20it%20affects%20%3CSTRONG%3E%3CU%3EONLY%3C%2FU%3E%20%3C%2FSTRONG%3Ethe%20current%20view.%3C%2FFONT%3E%3C%2FP%3E%3CP%3EWhen%20you%20%3CFONT%3Ehide%20(or%20unhide)%20%3CU%3E%3CSTRONG%3ECOLUMNS%3C%2FSTRONG%3E%20%3C%2FU%3Ein%20ANY%20view%2C%20it%20affects%20%3CU%3E%3CSTRONG%3EALL%3C%2FSTRONG%3E%20%3C%2FU%3Eviews.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

How do you hide columns without affecting other user's views on a shared Excel workbook?

8 Replies
Highlighted

@Emmylou66 

 

This is a question I too have...I posted a thread but have yet to receive any responses...

Highlighted

@Amanda_Fasano  Since this question was asked I have MORE. There are no "tracking" features on the online shared excel workbooks. Shared! No way to see who or when changes are being made. That is mind blowing.

Highlighted

@Emmylou66 

Are you referring to the legacy feature "Shared Workbook"?  I can't recommend using this and Microsoft encourages using 365's co-authoring.  The old Shared Workbook feature is not the most stable.

Highlighted

@Patrick2788 we are using the shared excel sheet through Office 365. What is "365's co-authoring"??

Highlighted

@Emmylou66 

Co-authoring is available when the workbook is stored on OneDrive or SharePoint.

 

https://support.office.com/en-us/article/Document-collaboration-and-co-authoring-EE1509B4-1F6E-401E-...

Highlighted

@Patrick2788  Thank you for this information. I appreciate it. Going to read up and see if this will work. We currently have close to 12 people working out of one shared excel database. It's been a nightmare, honestly. You cannot hide a column without messing up someone else's view, etc. 

Highlighted

@Emmylou66 

I think it's your best option and you'd have access to a version history of the workbook.

Highlighted

I agree with Patrick, the statement "You cannot hide a column without messing up someone else's view" ring true, from what I can gather thus far.

 

In summary;

When you hide (or unhide) ROWS in ANY view (filter), it affects ONLY the current view.

When you hide (or unhide) COLUMNS in ANY view, it affects ALL views.