Data validation dropdown: works in one sheet, not in another

P

Patrick Riley

I defined a pulldown validation list in Sheet3.
I inserted the reference to the list in Sheet1 and it works fine.
I inserted the reference to the list in Sheet2 and I'm told "the source
currently evaluates to an error".
The formatting of the relevant cells in Sheet1 and Sheet2 is identical.
Sheet and workbook protection is off in all sheets. Yes, I used the "="
(=ThruList).
Can anyone tell me why it works in one sheet and not the other?
---Pat Riley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Data Validation in XL2007 suddenly stops functioning 0
Data Validation in another sheet 1
Help changing the sheet name 3
Consistent Sheet column header rows 2
data validation works in one sheet but not another 1
Array code only works on selected sheet 14
Using Data Validation in a Table 0

Top