data validation works in one sheet but not another

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top