•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Viewing workbook online - protected sheet invisible in view but appears if set to edit
Our take
If you’re encountering a situation where a password-protected sheet in your workbook remains invisible in view mode, this is a common feature in many spreadsheet applications. Typically, protected sheets only become visible in edit mode to ensure data security. To allow users to view the protected content without switching to edit mode, consider adjusting the sheet's permissions or sharing settings. This way, you can maintain privacy while still empowering users to access the information they need without unnecessary barriers.
Not quite sure what's going on with this one.
I have been shown a worksheet that has 2 sheets, one blank and one password protected.
I am just view the spreadsheet online, I can't see the password protected sheet UNTIL I switch into edit mode. It then appears.
How can I have this sheet visible to users when simply being viewed?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Calculated cells are not displayed when in protected modeI'm generating an Excel file from software I'm writing. The spreadsheet contains numbers and some cells with formulas. This works fine. But when users download these files, all the cells that contain formulas are not displayed. They are simply blank. Not until the user hits the Enable Editing button do the calculated values appear. https://preview.redd.it/5vlwzrlrttsg1.png?width=1092&format=png&auto=webp&s=2a38bae278bf63ce2802b20efa1bb088d1f78f77 I understand this is some sort of protection. But I don't understand how hiding these cells protects anything. Is there any way to get these cells to appear when the spreadsheet is first downloaded and displayed. submitted by /u/NobodyAdmirable6783 [link] [comments]
- New cells added to a protected sheet will not lockI created a worksheet that required me to lock certain cells. The worksheet needed editing so I removed the protection so I could add additional columns. One of the two columns needs to be protected, while the other needs to be unlocked for data input. I made the unlocked range in the mange protection window and resumed protection on the worksheet but all new columns remained unlocked. All original cells on the worksheet (before the new colums) still lock and those that were put in an unlocked range remain unlocked. I am predominately working in the browser mode. I have used the desktop app to make sure all cells are locked in the fromat cells > protection settings. In the Manage Protection settings under options "Select locked celld" and "Select unlocked cells" are checked, everything else is unchecked. submitted by /u/middleCHILD-problems [link] [comments]
- 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]
Tagged with
#rows.com#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#Excel compatibility#google sheets#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#Excel alternatives for data analysis#financial modeling with spreadsheets#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#Excel alternatives#spreadsheet API integration#protected sheet#workbook#password protected