Excel Data Validation Drop Down Boxes
Posted on 2013-01-30
We have a spreadsheet that was created. 3 of the columns require a drop down box with various options for the users. The drop down box was created using the 'Data Validations' list feature. All of the options for the drop down box are stored in a tab within the same spreadsheet.
The person who created the spreadsheet is able to see the drop down box without any issue both locally as well as when he posts it to a shared network drive. However, any other user, with a Excel 2007 can not see the linked list or drop down options.