Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003-Data Validation drop down list not working?
Spreadsheet created in Excel 2003.
Drop down list in data validation cells works fine for me and most others, but have one person using the spreadsheet (in Excel 2000) that does not get a drop down list when cells selected. Have searched for causes in Help, but no results. Have saved file in earlier versions - no results. Is there some setting in his Excel version that could be interfering with data validation list display? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003-Data Validation drop down list not working?
ToolsOptionsViewObjectsShow All must be checkmarked fro DV dropdowns to
operate. Gord Dibben MS Excel MVP On Thu, 25 Sep 2008 04:47:01 -0700, Balcott wrote: Spreadsheet created in Excel 2003. Drop down list in data validation cells works fine for me and most others, but have one person using the spreadsheet (in Excel 2000) that does not get a drop down list when cells selected. Have searched for causes in Help, but no results. Have saved file in earlier versions - no results. Is there some setting in his Excel version that could be interfering with data validation list display? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Dropdown List Not Working | Excel Discussion (Misc queries) | |||
list validation drop-down not working | Excel Discussion (Misc queries) | |||
Excel 2007 and Drop Down List via Data Validation | Excel Discussion (Misc queries) | |||
Data Validation in Excel - drop down list font size | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel |