Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In-cell dropdown for validation stopped working
I have been using this function for years and now it has stopped working.
The validation setting are all still there, just no in-cell drop down. It only happens in one worksheet. (of course the one I need it in ;-) |
#2
|
|||
|
|||
Do you have freezed panes and excel 97? If so that is a known bug
Regards, Peo Sjoblom "Ourbriards" wrote: I have been using this function for years and now it has stopped working. The validation setting are all still there, just no in-cell drop down. It only happens in one worksheet. (of course the one I need it in ;-) |
#3
|
|||
|
|||
Hi
I had the same issue (using Excel 97). The only workaround at that time: - copy your data to a new workbook/worksheet - re-apply the filter/validation rules (you should be able to copy them) -- Regards Frank Kabel Frankfurt, Germany "Ourbriards" schrieb im Newsbeitrag ... I have been using this function for years and now it has stopped working. The validation setting are all still there, just no in-cell drop down. It only happens in one worksheet. (of course the one I need it in ;-) |
#4
|
|||
|
|||
Perhaps you inadvertantly unchecked "in cell dropdown"?
If not, see other posts for possibles. Gord Dibben Excel MVP On Fri, 17 Dec 2004 08:51:04 -0800, "Ourbriards" wrote: I have been using this function for years and now it has stopped working. The validation setting are all still there, just no in-cell drop down. It only happens in one worksheet. (of course the one I need it in ;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel stopped working | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Sum function not working correctly in Excel (Skips Cell) | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |