Validation in XP vs 2000

Giganews Newsgroups
Subject: Validation in XP vs 2000
Posted by:  John M (john.mart…@mackmultiples.com)
Date: Tue, 14 Oct 2003

I'm producing an application in excel which uses
validation to allow users to pick from a list in certain
cells.

I am using excel 2002 but other users in a different
company are using Excel 2000.

When they open the s/sheet in excel 2000 the validation
drop down lists do not appear.

Does excel 2000 support validation in the same way as
2002? Is there another reason why the validation might not
work on their PC?  What's the best/simplest alternative
way of incorporating drop down lists to limit the entries
users can make in cell?

Replies