Drop down lists and custom views functioning together

[Lori Brehmer]

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.

 

[Gord Dibben]

Lists and Dropdown lists are two enirely distinct entities.

Custom Views should not affect Data Validation dropdown lists........unless
you hide the rows or columns and make the dropdowns hidden.

If adding dropdown lists disabled custom views, you have something else
going on.

I have tested using DV dropdown lists and various custom views and cannot
disable either.


Gord Dibben MS Excel MVP