Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listen i datavalidering forsvinder
Jeg har et udgivelsesplan med ca. 1.200 titler som har oplysninger fordelt på 70 kolonner.
I de 8 kolonner har jeg en datavalidering, hvor jeg har en liste man kan vælge. (Hvilket giver ca. 10.000 lister) Mit problem er, at det rullefelt som burde være i cellen ikke er der. Er der nogen som ved hvorfor. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listen i datavalidering forsvinder
Hi Kurt,
Jeg har et udgivelsesplan med ca. 1.200 titler som har oplysninger fordelt på 70 kolonner. I de 8 kolonner har jeg en datavalidering, hvor jeg har en liste man kan vælge. (Hvilket giver ca. 10.000 lister) Mit problem er, at det rullefelt som burde være i cellen ikke er der. Er der nogen som ved hvorfor. (Sorry for the English reply!) Is it that the cell dropdown is missing? If so, that's controlled by the 'In-cell dropdown' check box on the Data Validation dialog Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listen i datavalidering forsvinder
Hi Stephen
There has been a mark in that box all the time, but it still dosn't work. A month ago, when only 4 columns had datavalidation, it worked. But after i expanded that functionality to 8 columns, the arrows dissapered. The funktionality works fine in other worksheets. Is there a maximum to how many it is possible to validate. Best regards Kurt "Stephen Bullen" skrev: Hi Kurt, Jeg har et udgivelsesplan med ca. 1.200 titler som har oplysninger fordelt på 70 kolonner. I de 8 kolonner har jeg en datavalidering, hvor jeg har en liste man kan vælge. (Hvilket giver ca. 10.000 lister) Mit problem er, at det rullefelt som burde være i cellen ikke er der. Er der nogen som ved hvorfor. (Sorry for the English reply!) Is it that the cell dropdown is missing? If so, that's controlled by the 'In-cell dropdown' check box on the Data Validation dialog Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listen i datavalidering forsvinder
Hi Kurt,
There has been a mark in that box all the time, but it still dosn't work. A month ago, when only 4 columns had datavalidation, it worked. But after i expanded that functionality to 8 columns, the arrows dissapered. The funktionality works fine in other worksheets. Is there a maximum to how many it is possible to validate. There's no limit that I know of. Have you set the window to use split or frozen panes? Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listen i datavalidering forsvinder
Hi Kurt
The panes have been frozen all the time. Best regards Kurt "Stephen Bullen" skrev: Hi Kurt, There has been a mark in that box all the time, but it still dosn't work. A month ago, when only 4 columns had datavalidation, it worked. But after i expanded that functionality to 8 columns, the arrows dissapered. The funktionality works fine in other worksheets. Is there a maximum to how many it is possible to validate. There's no limit that I know of. Have you set the window to use split or frozen panes? Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listen i datavalidering forsvinder
Hi Kurt,
The panes have been frozen all the time. Then I'm sorry, but you have me stumped. It might be worth posting the problem again (in English <g) and see if anyone else has any ideas. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.ie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listen to Your Customers | Excel Discussion (Misc queries) | |||
how to use a music icon and listen to part of a song title | New Users to Excel | |||
Wanna listen to music while surfing... | Excel Discussion (Misc queries) | |||
Wanna listen to music while surfing... | Setting up and Configuration of Excel | |||
Listen to network adapter | Excel Programming |