Results 1 to 4 of 4

Thread: Other users can't see drop-down list

  1. #1

    Question Other users can't see drop-down list



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    Do you both have the same version of Excel?
    Circumference of a circle = 2πr²



    ²the circle's radius

  3. #3
    Nope She has 2007 version, but I - 2010 version. Is this the problem? And if yes - how can this be fixed?

  4. #4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •