Drop downs issue on Mac Microsoft 2008

[kasperblue]

Hello,

I've set up a template in an Excel 2010 document on my Microsoft PC. The file uses drop downs using the data validation function.

The problem I'm having is that I've sent the file to a colleague whom only uses a Mac with Microsoft 2008 and the drop downs aren't functioning.

I've tried tweaking the file by only using the data validation source on the same sheet (rather than on a different tab) and i've tried saving in an older format i.e. 1997-2003 but the drop downs still arent working.

As I dont have a Mac with Microsoft 2008 I'm really struggling to know where to start to fix this - I do have a Mac with 2010 and it does work!! Can anyone offer any suggestions?

Many thanks

[TMS]

In the absence of any other offering, I would suggest that you make the range containing the drop down data a named range; if you intend to add data to it, it would be as well to make it a dynamic named range. Even if you're not, it wouldn't hurt.

For example:

=Sheet3!$A$2:INDEX(Sheet3!$A:$A,COUNTA(Sheet3!$A:$A))

This defines a workbook wide Named Range referring to Sheet3, cells A2 to ... well, whatever, is the last cell in that column. You cannot have blanks in this range.

I called it DV_List and you would put: =DV_List as the source in the Data Validation dialogue.

This approach should be compatible in all versions of Excel.


Regards, TMS

[JosephP]

if you post the workbook (no data required other than the dv source data) I can test it in 2008 and tell you why it doesn't work