I have data on another sheet in the same workbook that I am using as a source for a dropdown. It works in Excel 2010, but not in Excel 2007. I tried naming my list and using source =myRangeList where myRangeList is the name of the list. Again, it works in excel 2010, but not in excel 2007.

2 Answers
2

I solved this by having both Excel 2007 and 2010 installed.In Excel 2010 I selected the cell that should have contained the dropdown-list and then pressed data validation from the data tab. I just copied the values in excell 2007 and saved.

This worked for me. I think the problem is that 2007 doesn't let you select a range on another sheet, though you can type it in the box, making sure you include the sheet name.
–
paulmorrissMay 23 '13 at 15:18