Data validation failures

R

RogerNZ

I have several templates set up that are called by a master sheet. These sheets contain information with Data validation drop down lists. Excel is continually having problems with these data validation cells and commonly this is in the form of either only 1 cell with data validation drop down list functioning, or it is interfering with pictures on screen or it is moving combo boxes around the screen. This is not in code to do this either, it is very confusing and I am tempted to say that the data validation option has been very badly programmed!
Like I say these functions all work perfectly in the templates they are called from.
Help - I've spent several weeks setting this system up and it's making me look bad!
 
D

Dave Peterson

I don't think I've seen xl behave this way.

You may want to post the version of excel you're having trouble with.

I have seen trouble with data|validation in xl97 if the cell is above the
window|Freeze panes row.

And I've seen trouble with data|validation if the cell was merged.
 
Top