I have a workbook with 12 worksheets. Each work sheet has data validation
"list" with three choices in the dropdown. All worksheets use the same
referenced list that is located on a hidden worksheet. Row 7 of the first
worksheet worked well at one time and now it does not offer the dropdown when
the cells are selected, all the other worksheet work fine. There is other
data validation cells that work fine but they have a different list, time
selection, in the drop down. I went to "data validation" "remove all" (from
the row 7 on worksheet one that are not offering the dropdown), saved,
closed, opened again and re-did data validation, it still will not work!
Does anyone know what happened?

Mike Rogers

My guess is that you are outside of the data validation range for that
column. Check the range. Good luck.
Pat

"Mike R" wrote:

I have a workbook with 12 worksheets. Each work sheet has data validation
"list" with three choices in the dropdown. All worksheets use the same
referenced list that is located on a hidden worksheet. Row 7 of the first
worksheet worked well at one time and now it does not offer the dropdown when
the cells are selected, all the other worksheet work fine. There is other
data validation cells that work fine but they have a different list, time
selection, in the drop down. I went to "data validation" "remove all" (from
the row 7 on worksheet one that are not offering the dropdown), saved,
closed, opened again and re-did data validation, it still will not work!
Does anyone know what happened?

Mike Rogers

If you're using Excel 97 or earlier, data validation dropdowns don't
work in a frozen part of the window. Could that be the problem?

Mike R wrote:
I have a workbook with 12 worksheets. Each work sheet has data validation
"list" with three choices in the dropdown. All worksheets use the same
referenced list that is located on a hidden worksheet. Row 7 of the first
worksheet worked well at one time and now it does not offer the dropdown when
the cells are selected, all the other worksheet work fine. There is other
data validation cells that work fine but they have a different list, time
selection, in the drop down. I went to "data validation" "remove all" (from
the row 7 on worksheet one that are not offering the dropdown), saved,
closed, opened again and re-did data validation, it still will not work!
Does anyone know what happened?

Mike Rogers


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I am using xl2k... This did work at one time. Could it be caused by a macro?
I did add a data entry sheet and there is some code that changes the tab
name on each sheet as the data is entered. Other than that I have made no
significant changes to the wookbook, and none to the worksheet. If you know
why this is happening that would be cool, but my goal is to make it work
again! Thank you for you contribution on this forum, it is appreciated!!!

Mike Rogers

"Debra Dalgleish" wrote:

If you're using Excel 97 or earlier, data validation dropdowns don't
work in a frozen part of the window. Could that be the problem?

Mike R wrote:
I have a workbook with 12 worksheets. Each work sheet has data validation
"list" with three choices in the dropdown. All worksheets use the same
referenced list that is located on a hidden worksheet. Row 7 of the first
worksheet worked well at one time and now it does not offer the dropdown when
the cells are selected, all the other worksheet work fine. There is other
data validation cells that work fine but they have a different list, time
selection, in the drop down. I went to "data validation" "remove all" (from
the row 7 on worksheet one that are not offering the dropdown), saved,
closed, opened again and re-did data validation, it still will not work!
Does anyone know what happened?

Mike Rogers


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

If you copy that row to another sheet, does it work?

If not, can you delete row, and put the data validation on another row?


Mike R wrote:
I am using xl2k... This did work at one time. Could it be caused by a macro?
I did add a data entry sheet and there is some code that changes the tab
name on each sheet as the data is entered. Other than that I have made no
significant changes to the wookbook, and none to the worksheet. If you know
why this is happening that would be cool, but my goal is to make it work
again! Thank you for you contribution on this forum, it is appreciated!!!

Mike Rogers

"Debra Dalgleish" wrote:


If you're using Excel 97 or earlier, data validation dropdowns don't
work in a frozen part of the window. Could that be the problem?

Mike R wrote:

I have a workbook with 12 worksheets. Each work sheet has data validation
"list" with three choices in the dropdown. All worksheets use the same
referenced list that is located on a hidden worksheet. Row 7 of the first
worksheet worked well at one time and now it does not offer the dropdown when
the cells are selected, all the other worksheet work fine. There is other
data validation cells that work fine but they have a different list, time
selection, in the drop down. I went to "data validation" "remove all" (from
the row 7 on worksheet one that are not offering the dropdown), saved,
closed, opened again and re-did data validation, it still will not work!
Does anyone know what happened?

Mike Rogers


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra Thanks for the post back.

I went to the workbook to try that which you suggested.....and the thing now
works again!!!! Now should I be worried or thankful? Thank you for your
input and I will hope that "IT" has healed itself. If not I may just pitch
it off into the galactic bit bucket and start over!!!!

Mike Rogers

"Debra Dalgleish" wrote:

If you copy that row to another sheet, does it work?

If not, can you delete row, and put the data validation on another row?


Mike R wrote:
I am using xl2k... This did work at one time. Could it be caused by a macro?
I did add a data entry sheet and there is some code that changes the tab
name on each sheet as the data is entered. Other than that I have made no
significant changes to the wookbook, and none to the worksheet. If you know
why this is happening that would be cool, but my goal is to make it work
again! Thank you for you contribution on this forum, it is appreciated!!!

Mike Rogers

"Debra Dalgleish" wrote:


If you're using Excel 97 or earlier, data validation dropdowns don't
work in a frozen part of the window. Could that be the problem?

Mike R wrote:

I have a workbook with 12 worksheets. Each work sheet has data validation
"list" with three choices in the dropdown. All worksheets use the same
referenced list that is located on a hidden worksheet. Row 7 of the first
worksheet worked well at one time and now it does not offer the dropdown when
the cells are selected, all the other worksheet work fine. There is other
data validation cells that work fine but they have a different list, time
selection, in the drop down. I went to "data validation" "remove all" (from
the row 7 on worksheet one that are not offering the dropdown), saved,
closed, opened again and re-did data validation, it still will not work!
Does anyone know what happened?

Mike Rogers


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome, and I hope it's fixed! If the problem recurs, and the
workbook is important, I'd probably recreate it. In the meantime, make
sure you have a backup copy.

Mike R wrote:
Debra Thanks for the post back.

I went to the workbook to try that which you suggested.....and the thing now
works again!!!! Now should I be worried or thankful? Thank you for your
input and I will hope that "IT" has healed itself. If not I may just pitch
it off into the galactic bit bucket and start over!!!!

Mike Rogers

"Debra Dalgleish" wrote:


If you copy that row to another sheet, does it work?

If not, can you delete row, and put the data validation on another row?


Mike R wrote:

I am using xl2k... This did work at one time. Could it be caused by a macro?
I did add a data entry sheet and there is some code that changes the tab
name on each sheet as the data is entered. Other than that I have made no
significant changes to the wookbook, and none to the worksheet. If you know
why this is happening that would be cool, but my goal is to make it work
again! Thank you for you contribution on this forum, it is appreciated!!!

Mike Rogers

"Debra Dalgleish" wrote:



If you're using Excel 97 or earlier, data validation dropdowns don't
work in a frozen part of the window. Could that be the problem?

Mike R wrote:


I have a workbook with 12 worksheets. Each work sheet has data validation
"list" with three choices in the dropdown. All worksheets use the same
referenced list that is located on a hidden worksheet. Row 7 of the first
worksheet worked well at one time and now it does not offer the dropdown when
the cells are selected, all the other worksheet work fine. There is other
data validation cells that work fine but they have a different list, time
selection, in the drop down. I went to "data validation" "remove all" (from
the row 7 on worksheet one that are not offering the dropdown), saved,
closed, opened again and re-did data validation, it still will not work!
Does anyone know what happened?

Mike Rogers


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html