i have had the same problem as you regarding the dropdown tab showing. I'm on
XL2003. The only thing I can do is to copy entire data in the worksheet
having the problen to another worksheet, re-establish the links to my model
and then it works normally.

"John" wrote:

Saw posting on the Group on XL97 with Freeze frames etc, I'm on XL2002, I
just recreated the whole sheet and it worked fine

Thanks


"Frank Kabel" wrote in message
...
Hi
I heard from some 'corrupted' files esp. with Excel 97 (even had this some
time on my own). Easiest solution: Re-build the sheet

"John" wrote:

Is there any circumstances when a Data Validation Drop down Tab will not
display, other than having the 'In-cell dropdown' unselected?