If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Question

petes · 2006-09-25 08:21:46

Quick Excel question guys. I have an excel file with list of data. I have the top cell set up as a drop down list. Only thing is it is only showing about have the list in the drop down. I have went into Data/Validation and settings and ensured the range was correct. Anybody ever come across this? Thanks.

25-09-2006 8:21am

#1

petes

Registered Users, Registered Users 2 Posts: 8,382 ✭✭✭

Join Date: August 2002

Posts: 8127

Quick Excel question guys.

I have an excel file with list of data. I have the top cell set up as a drop down list. Only thing is it is only showing about have the list in the drop down. I have went into Data/Validation and settings and ensured the range was correct. Anybody ever come across this? Thanks.

0

Comments

#2 25-09-2006 8:29am

subway

Closed Accounts Posts: 6,131 ✭✭✭

Join Date: November 2005

Posts: 5469

thers a limit of 1000 on data displayed from a filter drop down.

anymore will be left off

0
#3 25-09-2006 8:36am

petes

Registered Users, Registered Users 2 Posts: 8,382 ✭✭✭

Join Date: August 2002

Posts: 8127

I only have 139 with 34 showing in the drop down.

0