| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"user has restricted values" in lookup
I am trying to do a lookup and I'm getting the error, "user has restricted
values that can be entered into this cell." How do I know which cell is restricted and what I need to do to unrestrict it? I have unprotected all my cells, etc. Also, a vlookup done here previously worked just fine so . . . at a bit of a loss. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 displays Locked by "another user", does not show User I | Excel Discussion (Misc queries) | |||
| excel displays "l" instead of "‚¬" symbol for Euro values | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Pivot table "restricted" output | Excel Discussion (Misc queries) | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
