I was using Custom views within my excel worksheets however when adding drop
down lists as a feature the customer views were automatically disabled.
Below is the info I found in the help section. Does anyone have a solution
to allow both customer views and down down lists to function in the same
worksheet??

Note You cannot create a custom view when a worksheet contains an Excel
list (list: A series of rows that contains related data or a series of rows
that you designate to function as a datasheet by using the Create List
command.). If one or more worksheets contain an Excel list, the Custom Views
command is disabled for the entire workbook.