If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drop down lists and custom views functioning together
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. |
#2
|
|||
|
|||
Drop down lists and custom views functioning together
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 On Wed, 20 May 2009 08:47:01 -0700, Lori Brehmer wrote: 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. |
Thread Tools | |
Display Modes | |
|
|