| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alert before overwriting cells
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alert before overwriting cells
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alert before overwriting cells
Hi Doc,
Actually my only goal was to understand why this option does not work correctly. I don't need to protect cells in this case; I was manipulating data in a spreadsheet and noticed that I was able to paste the data over the top of existing data without a prompt. Since the option is checked and should work, I'd like to know what's wrong. "docexcel" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alert before overwriting cells
Are you sure the alert options is not for when you "Move" data to a cell with
existing data. You would receive a warning - Do you want to replace the contents of the destination cells? "cottage6" wrote: Hi Doc, Actually my only goal was to understand why this option does not work correctly. I don't need to protect cells in this case; I was manipulating data in a spreadsheet and noticed that I was able to paste the data over the top of existing data without a prompt. Since the option is checked and should work, I'd like to know what's wrong. "docexcel" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
