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

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