I tried deleting the cell as you sugested and then inserting it back. When I deleted the cell and sifted up the cell that moveinto its place displayed the arrow just like it was before?????
One further detail that I didn't mention before is that the drop down arrow is present all the time - weather or not the cell is active. I rembered reading somewhere that the arrow on a normal lookup is only vissible when the cell is active.
I am working on a estimating app in excel and at one point put a drop down in one cell. Further development of the work book lead me to change the cell from a lookup with a drop down to a formual where the input for this cell would be inported from another cell in the work book. Thsi has been...