Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
restricted values error message
I was given a spreadsheet to fill in. All cells are unprotected, but when I
try to enter a number in the data cells, it says that I can't because the cell has "restricted values". The values for the cells are noted as 1-5. Entering those numbers, I get the error message, when I don't think I should. How can I "unrestrict" the restricted values? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
restricted values error message
I do suggest that you feedback to/discuss with the source party for the
spreadsheet, rather than mess around with the restrictions/controls imposed on your own. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Recordhop" wrote: I was given a spreadsheet to fill in. All cells are unprotected, but when I try to enter a number in the data cells, it says that I can't because the cell has "restricted values". The values for the cells are noted as 1-5. Entering those numbers, I get the error message, when I don't think I should. How can I "unrestrict" the restricted values? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
restricted values error message
Sounds like the cells have data validation applied. To check for that:
Select one of those cells Goto the menu DataValidation See any settings there? -- Biff Microsoft Excel MVP "Recordhop" wrote in message ... I was given a spreadsheet to fill in. All cells are unprotected, but when I try to enter a number in the data cells, it says that I can't because the cell has "restricted values". The values for the cells are noted as 1-5. Entering those numbers, I get the error message, when I don't think I should. How can I "unrestrict" the restricted values? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
restricted values that can be entered | Excel Worksheet Functions | |||
how do i cancel user restricted values in a cell | New Users to Excel | |||
Restricted values in cells | Excel Discussion (Misc queries) | |||
cells without values causing error message | Excel Discussion (Misc queries) | |||
error message - unable to save external link values | Excel Discussion (Misc queries) |