Not Being Prompted for Password When Entering Data In Protected Worksheet

Tan Tolentino 0 Reputation points

Anyone know why a protected worksheet will allow me to enter data without a password, yet will give a warning regarding password protection when I try to delete that data?

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,680 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Tanay Prasad 2,115 Reputation points


    This indicates that the worksheet has specific protection settings applied. It is typically due to the worksheet being protected with different levels of protection for different actions.

    There is-

    • Cell-level protection
    • Sheet-level protection
    • Workbook-level protection

    In case you want to modify the protection settings of a worksheet or workbook, follow these steps:

    1. Open your Excel workbook.
    2. Go to the "Review" tab in the Excel ribbon.
    3. Look for the "Protect Sheet" or "Protect Workbook" option in the "Changes" group. Click on it to open the protection settings dialog.
    4. In the protection settings dialog, you can view and modify the specific actions that are allowed or restricted. Review the settings related to deleting data or cell modifications.
    5. If necessary, enter the password if prompted to make changes to the protection settings.
    6. Adjust the settings as desired to align with your requirements. You may need to remove protection, modify existing protection settings, or apply a consistent level of protection across the worksheet or workbook.

    I hope this explains it.

    Best Regards.

    0 comments No comments