Other users can't see drop-down list

curly

New member
Joined
Apr 24, 2013
Messages
7
Reaction score
0
Points
0
Hi!

I've prepared table which contains cells where data validation tool is applied (drop down list). Just sent to my colleague, but she cannot see these drop down lists. Any suggestions? :)
 

JoePublic

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
223
Reaction score
2
Points
18
Location
UK
Excel Version(s)
2016
Do you both have the same version of Excel?
 

curly

New member
Joined
Apr 24, 2013
Messages
7
Reaction score
0
Points
0
Nope :( She has 2007 version, but I - 2010 version. Is this the problem? And if yes - how can this be fixed?
 

curly

New member
Joined
Apr 24, 2013
Messages
7
Reaction score
0
Points
0
Already found the solution (even two):):

(1) Name the ranges of the lists you are using and then use those names when sourcing the lists for the cells;
(2) Download Microsoft Compatibility pack
 
Top