Excel 2003-Data Validation drop down list not working?

B

Balcott

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
 
G

Gord Dibben

Tools>Options>View>Objects>Show All must be checkmarked fro DV dropdowns to
operate.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Created invoices in Excel - not working in Drive 1
Data Validation 1
Formatted cell column in drop down list 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
data validation fonts differ in drop down box 1

Top