Share via

Unchecking "Alert before overwriting cells" doesn't work

Anonymous
2023-03-24T02:12:07+00:00

Sorry the image is in Korean, but when I wanted the "There's already data here. Do you want to replace it?" message disabled, so I unchecked the box at the following settings:

File > Options > Advanced > Editing options > Enable fill handle and cell drag-and-drop > Un-check "Alert before overwriting cells"

Sadly the message is still showing up. Any fix?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-10T17:08:35+00:00

    I've having this same issue. I followed all your steps and there were no conditional formating rules to begin with, no data validation rules, and no protection to the worksheet. I never got this message in the past and like EunohLee, I have unchecked "alert before overwritting cells".

    This must be some sort of coding error with the update to excel.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-03-24T04:53:03+00:00

    Hi EunohLee!

    I'm sorry to hear that you're having trouble with messages coming up when you tried to edit cells in your Excel File.

    Does this happen in all the excel file?

    Please try the following:

    1. Check if there is any conditional formatting being applied, * Select the cells where you are experiencing the issue. * Go to the "Home" tab on the Excel ribbon. * In the "Styles" group, click on "Conditional Formatting" and select "Manage Rules". * In the "Conditional Formatting Rules Manager" dialog box, look for any rules that may be applied to the cells you selected. * If you find any rules that are causing the issue, select them and click on "Delete". Click "OK" to close the "Conditional Form
    2. Try to remove any data validation rules or protection settings that may be causing the issue: * Select the cells where you are experiencing the issue. * Go to the "Data" tab on the Excel ribbon. * In the "Data Tools" group, click on "Data Validation" and select "Data Validation". * In the "Data Validation" dialog box, look for any rules that may be applied to the cells you selected. * If you find any rules that are causing the issue, select them and click on "Clear All". * Click "OK" to close the "Data Validation" dialog box. * If there is a worksheet protection applied to the worksheet, go to the "Review" tab on the Excel ribbon. * In the "Changes" group, click on "Unprotect Sheet" and enter the password if prompted.

    * Try to overwrite the cells again and see if the message is still appearing.

    Kindly let me know, if you require additional assistance, I will be glad to help further.

    Best Regards, Shakiru

    0 comments