I have created a dropdown list in Windows NT, Excel 2002. The dropdown is in
multiple workbooks on a shared drive. The workbooks however, are not shared
workbooks. We are having a problem with all users being able to use the
dropdown.

The box/arrow is in each cell, but either the list doesn't appear or an
error message is received when clicking in any cell. How can we remedy this?