Maintain hidden rows/columns in "sheet view" so other users are not affected by the change
Sheets view offers a private view of the Excel sheet when sorted or filtered, another common change is hiding rows/columns but that currently affects all users when sharing document.
Allow for row/column views to remain private in Sheet View so others are not affects.
Troy Finney
shared this idea
27 comments
-
Abner
commented
it's been so many years since MS offered team collaboration on Office products. This shouldn't take this long to resolve. ONLY changes from any user should be synced so all users see, do NOT sync how 1 user views the document - be it filter, hidden column, etc. Come on MS! Google Docs offers such features years ago. Catch up.
-
Anonymous
commented
totally agree on this
-
Anonymous
commented
a very frustrating omission from co authoring
-
Anonymous
commented
This is becoming a huge issue. Having custom views that don't reset to default once a column is hidden or expanded is critical. Otherwise we're looking at having to maintain multiple spreadsheets with the same information or having to manually adjust rows/columns for each view each and every time. This really needs to be fixed. We are using this in Teams.
-
Anonymous
commented
why would the current sheet view feature be limited to sorting and filtering? I dont understand why it would not include columns/row hiding as well.
-
Anonymous
commented
Agree with the need for support in "Sheet Views" for hide/group/widths!
-
Bertrand Martin-Garin
commented
Hi.
at the bottom of the sheet, there is a first horizontal scrollbar which allows to navigate right to left within the sheet, there is also a second scrollbar which controls the navigation between the tabs of the document. This scrollbar hides all the tabs and it is very difficult to choose one of them.
I wish to hide the scrollbar which controls the tab navigation -
Joseph Wal
commented
Adding the views created by Split and Freeze Panes to the list would be helpful as well.
-
Bryan
commented
Changing the width/height of the column/row also seems to affect other's sheet view while working on the file at the same time.
So things that need improvement that are currently affecting others are:
1. Hide/Unhide the rows/columns
2. Group/Ungroup the rows/columns
3. Change the widths/heights of the rows/columnsIf anyone has more issues, you can add to this list.
Hope to have these fixed as soon as possible. -
Lindsay Short
commented
This would make sharing larger data sets where different users have different needs much more practical - at the moment it makes this type of sharing via sharepoint useless for our data sets
-
JC
commented
this is making Excel on the Web unworkable for us - team are starting to look at alternatives
-
Kevin
commented
Also sheet view NEEDS to be added to the desktop version, but ONLY with this feature.
Microsoft, you can't push a product as an enterprise solution and then not allow enterprise collaboration without a bunch of special rules and recommendations how suddenly now that you're Office 365 you have to change your ENTIRE workflow. How do you expect 100 people or more to work on a spreadsheet at the same time and not ***** each other over without private views?
-
Bryan
commented
One additional request:
Grouping/Un-grouping the columns/rows also affecting others. So need these remain personal when using Personal Sheet View.
-
fe
commented
agreed, it is currently inconsistent with excel desktop..
-
Martin
commented
The same problem, if someone disable filters, it disable it for all views. Can that be added to the mentioned idea?
-
Anonymous
commented
afas
-
Lauren
commented
Why doesn't Teams have the same functionality as SharePoint where multiple people can work on a document at the same time?
-
Noe Lavigne
commented
+1 here
Seriously need this function to applied when you Hide COLUMNS !!
The view tabs in Excel online add no value compared to a simple filter except that it is a saved filter setting...Need the same can of view capability compared to the desktop version
-
Anonymous
commented
Microsoft needs to learn from Airtable. The views there are handled in such a orderly fashion, it's incredible. Not here to advertise the software, but rather point someone in the Microsoft development team to look at a tool that has gone beyond just a basic spreadsheet tool.
-
[Deleted User]
commented
This would definitely be handy. We have a task progress board and with many columns it can be difficult to scroll through - some users only need to be aware of certain stages of progress so hiding columns for them would save a lot of time scrolling.
