Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

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.

If you find the sheet to be protected, you can use this solution : http://mcgimpsey.com/excel/removepwords.html

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.