| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation - Allow List - In-cell Dropdown not showing up
This is in a MS Office 97 Excel Workbook, although I have selected data
validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation - Allow List - In-cell Dropdown not showing up
Are you using windows|freeze panes?
Is your cell with Data|validation above that line? If yes, move the cell or remove the data|validation. It's a bug in xl97, fixed in xl2k. Patrick Gibbons wrote: This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation - Allow List - In-cell Dropdown not showing up
I think Dave meant,... "or remove the freeze panes"
You could use WindowSplit instead Dave Peterson wrote: Are you using windows|freeze panes? Is your cell with Data|validation above that line? If yes, move the cell or remove the data|validation. It's a bug in xl97, fixed in xl2k. Patrick Gibbons wrote: This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation - Allow List - In-cell Dropdown not showing up
Yes, I did. I was distracted by some XSPAM problems.
Debra Dalgleish wrote: I think Dave meant,... "or remove the freeze panes" You could use WindowSplit instead Dave Peterson wrote: Are you using windows|freeze panes? Is your cell with Data|validation above that line? If yes, move the cell or remove the data|validation. It's a bug in xl97, fixed in xl2k. Patrick Gibbons wrote: This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation - Allow List - In-cell Dropdown not showing up
If you didn't use your real email address in the public newsgroups,
maybe you wouldn't get so much XSPAM! Dave Peterson wrote: Yes, I did. I was distracted by some XSPAM problems. Debra Dalgleish wrote: I think Dave meant,... "or remove the freeze panes" You could use WindowSplit instead Dave Peterson wrote: Are you using windows|freeze panes? Is your cell with Data|validation above that line? If yes, move the cell or remove the data|validation. It's a bug in xl97, fixed in xl2k. Patrick Gibbons wrote: This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation - Allow List - In-cell Dropdown not showing up
My name Jose Jimenez.
(apologies to Bill Dana) or.... mmmmm. XSPAM. (apologies to Homer Simpson) Debra Dalgleish wrote: If you didn't use your real email address in the public newsgroups, maybe you wouldn't get so much XSPAM! Dave Peterson wrote: Yes, I did. I was distracted by some XSPAM problems. Debra Dalgleish wrote: I think Dave meant,... "or remove the freeze panes" You could use WindowSplit instead Dave Peterson wrote: Are you using windows|freeze panes? Is your cell with Data|validation above that line? If yes, move the cell or remove the data|validation. It's a bug in xl97, fixed in xl2k. Patrick Gibbons wrote: This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson |
|
#7
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation - Allow List - In-cell Dropdown not showing up
Hi Debra
this is one of the nice things with NG :-) You have to constantly adapt your filters :-( On a sidenote: though in english NG it's o.k. to use false email addresses in most German NGs (like the German Excel NG) this is considered against the rules (same is true for not using real names) "Debra Dalgleish" schrieb im Newsbeitrag ... If you didn't use your real email address in the public newsgroups, maybe you wouldn't get so much XSPAM! Dave Peterson wrote: Yes, I did. I was distracted by some XSPAM problems. Debra Dalgleish wrote: I think Dave meant,... "or remove the freeze panes" You could use WindowSplit instead Dave Peterson wrote: Are you using windows|freeze panes? Is your cell with Data|validation above that line? If yes, move the cell or remove the data|validation. It's a bug in xl97, fixed in xl2k. Patrick Gibbons wrote: This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#8
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation - Allow List - In-cell Dropdown not showing up
As you suspected the freeze panes was the problem . . . that is a silly bug
.. . . Oh well. Thank you, now which choice will I use . . . No matter, I'll figure that out. At least now I know what's up. Thank you again, Patrick Gibbons "Dave Peterson" wrote in message ... Are you using windows|freeze panes? Is your cell with Data|validation above that line? If yes, move the cell or remove the data|validation. It's a bug in xl97, fixed in xl2k. Patrick Gibbons wrote: This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Validation - Allow List - In-cell Dropdown not showing up
I dunno smart guy, it works for me.
Patrick Gibbons wrote: This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly person would tell me that I don't have the In-cell Dropdown checkbox selected . . . got it smart guy. It is still not working. I will give you the current setup: Cell L4 has the current data validation: Allow: List Source: =$B$54:$B$65 Ignore blank - selected In-cell Dropdown - selected Cells B54:B65 January February March . . . etc. Anyone have any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation with dropdown list | Excel Discussion (Misc queries) | |||
| Substition for data validation, dropdown list | Excel Worksheet Functions | |||
| blanks in data validation list dropdown | Excel Worksheet Functions | |||
| size of data validation dropdown list | Excel Worksheet Functions | |||
| Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
Hybrid Mode
