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.

Anybody know what why it doesn't work in Excel 2007?