If your goal is to not have the data in the cell replaced, make sure the
Format Cells / Protection / Locked is checked and then protect the worksheet
with the Tools / Protection / Protect Sheets.

"cottage6" wrote:

I have this alert option checked, but I'm still allowed to overwrite cells
with data in them. I have Excel 2000, SR 9.0.3821 SR-1. Has anyone else had
this problem, and is there a solution? TIA