Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locked Cells
I have been using an excel file for a few weeks with no issues, all of a
sudden I am getting an error message: The value you entered is not valid. A user has restricted values that can be put into this cell. Retry. Cancel. I started this workbook, I have done a fair amount of copy pasting into it. With no issues. How do I unprotect. Please advise. Microsoft 2002 is in use here. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locked Cells
Select the cell, go to Data Validation. and check whats there.
"PAL" wrote in message ... I have been using an excel file for a few weeks with no issues, all of a sudden I am getting an error message: The value you entered is not valid. A user has restricted values that can be put into this cell. Retry. Cancel. I started this workbook, I have done a fair amount of copy pasting into it. With no issues. How do I unprotect. Please advise. Microsoft 2002 is in use here. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked cells | Excel Discussion (Misc queries) | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
locked cells | Excel Worksheet Functions | |||
locked cells | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions |