data validation works in one sheet but not another
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 |
data validation works in one sheet but not another
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 "Patrick Riley" wrote: 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 |
All times are GMT +1. The time now is 01:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com