data validation works in one sheet but not another

[Guest]

I defined a pulldown data-validation menu in Sheet3.
I put a reference to it in Sheet1, and it worked OK. I put a reference to it
in Sheet2, and it failed, telling me it evaluates to an error. Formatting of
relevant cells is identical, sheet & workbook protection is (currently) off.
Any reason why it would work in one sheet and not in another?
---PR

 

[Guest]

I"m not sure if the last post worked. I'm guessing you are trying to use a
list from Sheet2 on SHeet3. Take a look here and see if it helps.

http://www.contextures.com/xlDataVal05.html

HTH,
Barb Reinhardt