Drop down Arrow not showing

tgnarl

New Member
Joined
May 4, 2006
Messages
13
I've made a spreadsheet using drop down validation lists. It works for all users except for one person. They are using Excel 2007 on a Windows 7 computer. They cannot see the arrow to show the list of options. The cell is not locked. If the user types in a valid entry, it works.
I've tried to save the file in xls format, vs. xlsx. Still no difference.

Anyone have a suggestion?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
so the box works, it just doesnt have the arrow?
did you try ,ON THEIR PC, removing it and using the drop box on that pc?
 
Last edited:
Upvote 0
so the box works, it just doesnt have the arrow?
did you try ,ON THEIR PC, removing it and using the drop box on that pc?

Um, no I didn't. The thing is, this is a standard file that is used by many people on the network. The idea is to open it, rename the file and then enter your data. So, while I could do that once, it would keep happening when opening that one file.

Two minutes later ...

I opened the file on the offenders computer, and found that there was no data validation of the problem cells (funny 'cuz it shows up on my computer). Anyway, I added the data validation and it all seems to work now.

Thanks for the suggestion.
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,187
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top