• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Drop Down Lists on Excel 2010 vs 2007

S

s_k_s

New Member
This is driving me up the wall so any help would be appreciated.


Created multiple tabs in Excel 2010 with all drop down lists on one tab. Works fine in 2010 which is used internally.


When I e-mailed it externally people using 2007 started complaining that drop downs can't be viewed.


I have saved the document as an Excel 97-2003 doc.


One of the reasons I have come to understand is that freeze panes and drop downs don't get on with each other, so fine I got rid of freeze panes but still some drop downs are missing.


I thought it might be that Excel 2007 doesn't like the drop downs being on one tab but then why do some drop downs on some tabs work but others don't? If needs be I can put the drop downs on each individual tab but that is a lot of work and before I do that just wanted someone to confirm if that is the fix or is there something obvious that I am missing.
 
To clarify:

When you say drop downs, are those

a) Data validation drop downs

b) Forms toolbar dropdowns

c) ActiveX toolbar dropdowns


Also, might be helpful to upload a copy of your workbook for us to view, or try moving the sheets to a new workbook and saving (in case there's workbook corruption).
 
Hi, s_k_s!


Should this help?

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-drop-down-disappears-when-file-is/3dcc4f16-3231-4a4b-8492-4f0be3150e4d

Check 1st answer about saving file as .xlsm.

Or this:

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-2007-data-validation-compatibility/20a6e301-f5b7-459a-9ee4-867496342119


There're many issues regarding this problem:

http://www.excelforum.com/excel-programming-vba-macros/761540-drop-down-list-and-macro-work-excel-2010-but-not-2007-a.html

http://stackoverflow.com/questions/7235093/data-validation-set-in-excel-2010-fails-in-excel-2007

http://stackoverflow.com/questions/7715684/drop-down-list-compatibility-issue-between-excel-2007-and-excel-2010

http://www.ozgrid.com/forum/showthread.php?t=150080


Regards!
 
Hi, s_k_s!

Glad to help you. Thanks for your feedback and for your kind words too. Tell us how did you go on and welcome back whenever needed or wanted.

Regards!
 
You must log in or register to reply here.
Back
Top