Sheet Protect in Excel Online

[rgreene845]

Hi Community, 

I am trying to use sheet protect in Excel for Web version through my company outlook/sharepoint account. I have been able to use this feature before in the web version. I have multiple workbooks under the same account with protected sheets, all of which are shared files, but for some reason I cannot access sheet protection on a workbook I'm currently using or any new workbook I've tried to open while troubleshooting this issue. I have made sure no other users are currently in the workbook. I have ensured the workbook is not opened in another tab. I have exited the browsers completely and tried again. I really don't know why I can't perform this operation. I can't even protect the entire workbook. Also, worth mentioning, I am the author of all the workbooks I've referenced here as well, so I'm just at a loss here. Hoping someone might be familiar with this issue... 

If any of you know what might be causing this issue, please let me know. Any advice would be greatly welcome. 

Thank you!

[#2]

@rgreene845 

If you are experiencing difficulties protecting sheets in Excel Online through your company's Outlook and SharePoint account, there are several potential reasons and solutions you can explore:

1. Browser Compatibility:
• Ensure that you are using a compatible browser. Microsoft recommends using the latest version of Microsoft Edge, Google Chrome, Safari, or Mozilla Firefox for the best experience with Excel Online.
2. Browser Extensions:
• Some browser extensions may interfere with the functionality of web applications. Try disabling browser extensions to see if it resolves the issue.
3. Browser Cache and Cookies:
• Clear your browser's cache and cookies, as they can sometimes cause unexpected behavior.
4. Incognito/Private Browsing Mode:
• Open your browser in incognito or private browsing mode. This will start a new session without any cached data or extensions, helping to isolate potential issues.
5. Check Permissions:
• Ensure that you have the necessary permissions to edit and protect sheets in the workbook. Even if you are the author, check the sharing settings and permissions.
6. Network Issues:
• Connectivity issues or network restrictions may affect your ability to perform certain actions. Try accessing the workbook from a different network or location.
7. Browser Security Settings:
• Review your browser's security settings and make sure they are not preventing certain actions on web applications.
8. Microsoft 365 Service Status:
• Check the Microsoft 365 Service Health status to see if there are any ongoing issues or outages affecting the service.
9. Web App Updates:
• Ensure that your web apps are up to date. Sometimes, Microsoft rolls out updates that address bugs and improve performance.
10. Try Different Devices:
• If possible, try accessing the workbook and protecting sheets from a different device to see if the issue persists.
11. Use Desktop Version:
• If you have access to the desktop version of Excel, try using it to see if you can protect sheets without any issues.

I hope I was able to help you a little, if not... please just ignore it.

[#3]

@NikolinoDE Thank you so much for being so thorough in your response. I will troubleshoot your recommendations and hopefully one of them will correct the issue. Even if they don't, thank you again for responding and offering some insight. I genuinely appreciate it!