A
Alchemist
I ahve no idea what it is called but will try to explain.
I have a vloolup table on one sheet and another with combo dropdown lists
used in excel 2003 on my pc at home and on my work pc that when an item is
required for selection or entry using the combo drop down boxes, the initial
letters of the product entered are searched on by those characters. However,
when this excel file is sent to other users, it works on some pcs at work and
not others. The combo drop down box will not open up (when i double click the
cell to search by characters entered from the vlkup) but only the list box
will drop down showing some 8 items from the vlkup table instead of a long
list. The combo box dropdown list opens many choices from the vlkup table
when it is working on my pcs.
Why does this occur, on some pcs the default setup for first time users
(LAN), the combo list box will not open up but only the list box on their pc
yet some pcs it works?
I've tried to use the Options in excel to find the problem but have no idea
which combination of checkboxes to mark.
The pcs are LAn networked and when someone logs into a pc they have never
used before, a default office setup occurs for that new user on the system.
Is there one way to fix this combo list problem? It's annoying many people.
thank you very much.
I have a vloolup table on one sheet and another with combo dropdown lists
used in excel 2003 on my pc at home and on my work pc that when an item is
required for selection or entry using the combo drop down boxes, the initial
letters of the product entered are searched on by those characters. However,
when this excel file is sent to other users, it works on some pcs at work and
not others. The combo drop down box will not open up (when i double click the
cell to search by characters entered from the vlkup) but only the list box
will drop down showing some 8 items from the vlkup table instead of a long
list. The combo box dropdown list opens many choices from the vlkup table
when it is working on my pcs.
Why does this occur, on some pcs the default setup for first time users
(LAN), the combo list box will not open up but only the list box on their pc
yet some pcs it works?
I've tried to use the Options in excel to find the problem but have no idea
which combination of checkboxes to mark.
The pcs are LAn networked and when someone logs into a pc they have never
used before, a default office setup occurs for that new user on the system.
Is there one way to fix this combo list problem? It's annoying many people.
thank you very much.