Forum Discussion

RuthEllen's avatar
RuthEllen
Copper Contributor
Apr 10, 2024

Remove protection range Web Excel

I added a few Unlocked Ranges to my Manage Protection settings and I can not remove them now that I need to change the range.

There are three dots to the right of the Range but nothing happens when I click on them. I can't edit the ranges and I can't removed them. 

Thank you for any help you can offer.

-Ruth

Excel for web
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Apr 11, 2024

    RuthEllen 

    It seems like you are encountering an issue with managing protection settings in Excel for the web. Unfortunately, Excel for the web may have limitations compared to the desktop version when it comes to managing protection settings and unlocked ranges.

    Here are a few steps you can try to resolve the issue:

    1. Refresh the Page: Sometimes, refreshing the page can resolve minor glitches. Try refreshing the browser tab where you are working on Excel for the web.
    2. Use a Different Browser: If the issue persists, try accessing Excel for the web using a different web browser. Sometimes, certain browser settings or extensions can interfere with the functionality of web applications.
    3. Clear Browser Cache: Clearing the cache and cookies of your web browser can sometimes resolve issues related to web applications. You can usually find this option in the browser settings.
    4. Try the Desktop Version: If possible, try accessing the Excel file using the desktop version of Excel. The desktop version usually offers more robust features and options for managing protection settings.

    If you are still unable to remove the unlocked ranges from the protection settings, it's possible that there may be a limitation or bug in the Excel for the web application. In such cases, reaching out to Microsoft support would be the best course of action to address the issue.Formularbeginn The text and steps was created with the help of AI.

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.