Sheet views NOT KEEPING hidden columns
Our take
I'm working in Excel App for Mac and trying to use Sheet Views to make a large shared document easier for multiple departments to use.
Context:
The file is a big operational template where several departments work on the same sheet but each one only needs to see and edit certain columns. My idea was to create saved Sheet Views for each department so that when they switch to their view, only the relevant columns are visible.
What I'm experiencing:
• I create a Sheet View
• I hide the columns that department does not need
• I save the view
But when I switch back to Default View and then return to that saved view, the columns are no longer hidden. Everything is visible again. It seems like the hidden columns are not actually being preserved inside the Sheet View.
What I'm trying to achieve:
Each department opens the file → switches to their view → only sees their relevant columns → edits those fields → changes affect the master sheet.
Would appreciate any workflows people have used for this type of situation.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Sheet View not working in Excel online/Excel for the web/Excel web version even when hosted in OneDriveI have a question regarding Excel for the web, aka Excel online and Excel web. My team accesses Excel online via OneDrive. We would like to use sheet view in order to not see each other's sorting when we are all editing a sheet at once. However, we find that we are seeing each other's sorting even with sheet views turned on. I have tried to find the answer by going though MS support articles, chatting with representatives, and using the Q&A forum where the AI answers the question. I have a screen recording demonstrating the problem. Any insight would be greatly appreciated. Some information that may be useful: This issue happens regardless of how many team members are simultaneously editing the sheet. It's as though sheet view is not turned on at all We have tried using sheet view when both members are using a different sheet view, as well as when only one member is using sheet view and the other is using the Default view. The result is the same - we both only see the default view, as though sheet view is not turned on at all Sheet view is not grayed out in the toolbar. It appears fully active and functions exactly as described in the page linked above, with the exception that there is no effect on how spreadsheets appear to us (we all continue to see the Default view, and each other's sorting, when sheet view is turned on) Our team setup meets all of the conditions described in the AI response to my Q&A post, which I will paste here: If everyone is: - Working in the same workbook stored on OneDrive/SharePoint, and - Actually in a non-default Sheet View (eye icon visible, view selected from the Sheet View menu), and - Using sorts/filters (not global hide/unhide in default view), then each person’s Sheet View should prevent them from seeing each other’s sorts and filters in Excel for the web. If the behavior still matches “everyone only sees the default view,” the next checks are: - Confirm the file is opened from OneDrive/SharePoint (not a downloaded local copy). - Confirm each person has explicitly selected a named Sheet View (or the temporary view) from View > Sheet View, and sees the eye icon on the sheet tab. - Ensure sorts/filters are applied after entering the Sheet View, not before. submitted by /u/annie_m_m_m_m [link] [comments]
- Preventing Temp Views on 365How do I prevent staff from creating a temporary view on a shared worksheet? We are using 365 in SharePoint. What is frustrating is that I have two identical sheets created from the same template for two different divisions in the same workbook. One region's sheet is creating temporary views daily or several times a day. Where the second division's sheet does not have this problem & never has. I reviewed both sheets & I can't find any difference. I turned off autosave on the sheet that is creating the temp views, because that was the only difference between the two sheets. Everyone is annoyed, complaining & my boss is pissed. Please help! submitted by /u/accidentw8ng2happen [link] [comments]