Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-down list in datavalidating dissapeares
I have a plan with approx 1.200 titles and 70 columns.
In 8 columns I have datavalidating with a drop-dovn list. (That gives approx 10.000 drop-down lists). My problem is that the drop-down list dissapeared when I expanded from 4 to 8 columns with drop-down lists. The drop-down list works fine in a previous version and in other worksheets. Is there a limit to how many it is possible to validate? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-down list in datavalidating dissapeares
Don't know of a published limitation. If you are saying that the 8
column/10000 list version worked on other computers, that would be an indication it isn't a built in limitation of Excel, but may be constrained by memory or some other local PC factor. -- Regards, Tom Ogilvy "Kurt" wrote in message ... I have a plan with approx 1.200 titles and 70 columns. In 8 columns I have datavalidating with a drop-dovn list. (That gives approx 10.000 drop-down lists). My problem is that the drop-down list dissapeared when I expanded from 4 to 8 columns with drop-down lists. The drop-down list works fine in a previous version and in other worksheets. Is there a limit to how many it is possible to validate? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-down list in datavalidating dissapeares
OK. Still don't know of a published limit. But I would suspect that there
are probably memory limitations. You might look around www.decisionmodels.com and see if Charles mentions any limitations. -- Regards, Tom Ogilvy "Kurt" wrote in message ... Hi Tom Reading my quistion again, I wasn't very clear. The worksheet dosn't work on other computers. But in other and smaller worksheets, the drop-down list work on my computer. Kurt "Tom Ogilvy" skrev: Don't know of a published limitation. If you are saying that the 8 column/10000 list version worked on other computers, that would be an indication it isn't a built in limitation of Excel, but may be constrained by memory or some other local PC factor. -- Regards, Tom Ogilvy "Kurt" wrote in message ... I have a plan with approx 1.200 titles and 70 columns. In 8 columns I have datavalidating with a drop-dovn list. (That gives approx 10.000 drop-down lists). My problem is that the drop-down list dissapeared when I expanded from 4 to 8 columns with drop-down lists. The drop-down list works fine in a previous version and in other worksheets. Is there a limit to how many it is possible to validate? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |