I have written a spreadsheet using data validation to control input to
certain fields using a dropdown list for the user to pick from. The master
copy is working fine.

I am aware that if data is copy and pasted into the cells the data
validation is ignored and removed from the cells (I believe this may have
happened)

I have taken action to delete the current data in the cells and re-set up
the data validation however the drop down list does not appear. Furthermore
data validation using a dropdown list does not appear to work anywhere else
within the sheet (but can be set up on other sheets within the file).

I can only assume that somewhere within excel there is the ability to
suppress showing drop down data validation lists in a particular sheet (if so
I cannot find the option) or there is an excel error that is preventing a
drop down data validation list from showing.

Could you please advise on how to display the drop down list or obtain if
this is a known excel error. An explanation of how it occurs would be useful
as the user cannot remember what they did!!

Could you please advise on how to display the drop down list or obtain if
this is a known excel error. An explanation of how it occurs would be useful
as the user cannot remember what they did!!

Just some thoughts and empathy ... Recollect some past posts discussing this
phenomena. Experienced it once myself a few years ago in an xl97 file. Could
find no way to re-activate the droplists on that one particular sheet. All
droplists suddenly plain disappeared, just like that. Don't think I did
anything wrong, was just working as usual on the sheet. Had to re-build that
particular sheet on a new sheet. A backup file did help in cutting down the
re-build effort.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mattdsc" wrote:
I have written a spreadsheet using data validation to control input to
certain fields using a dropdown list for the user to pick from. The master
copy is working fine.

I am aware that if data is copy and pasted into the cells the data
validation is ignored and removed from the cells (I believe this may have
happened)

I have taken action to delete the current data in the cells and re-set up
the data validation however the drop down list does not appear. Furthermore
data validation using a dropdown list does not appear to work anywhere else
within the sheet (but can be set up on other sheets within the file).

I can only assume that somewhere within excel there is the ability to
suppress showing drop down data validation lists in a particular sheet (if so
I cannot find the option) or there is an excel error that is preventing a
drop down data validation list from showing.

Could you please advise on how to display the drop down list or obtain if
this is a known excel error. An explanation of how it occurs would be useful
as the user cannot remember what they did!!

Here's a relevant past discussion in google:
http://tinyurl.com/q8uun

Anyway, do hang around awhile for possible drop-ins by others
All the best
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks for the reply, Max.

Much appreciated.


"Max" wrote:

Here's a relevant past discussion in google:
http://tinyurl.com/q8uun

Anyway, do hang around awhile for possible drop-ins by others
All the best
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

You're welcome, Matt!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mattdsc" wrote:
Thanks for the reply, Max.
Much appreciated.