Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

If you find the sheet to be protected, you can use this solution :

Hope it helps

share|improve this answer
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. – paulmorriss May 23 '13 at 15:18

Since the range is on another sheet, make sure the sheet name is included in the name definition. If you use the name on sheet1 but the range is on sheet2 make sure your name gets defined in sheet1 as

Refers to: =Sheet2!$A$1:$A$10

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .