Combo box issue - Is there a limit on rows in Excel 2003?

Giganews Newsgroups
Subject: Combo box issue - Is there a limit on rows in Excel 2003?
Posted by:  Six Lombardi's (manningf…@gmail.com)
Date: Tue, 18 Jan 2011

Using Excel 2003 and I'm a total n00b with it.  I'm a database snob
and so Excel is NOT a database, but my employer wants it so he gets
it...

Anyway, I created a combo box and linked it to a named field.
Depending on the value of Cell A:3, the combo box runs a query and
fills the named field with values.  This all works fine and dandy.

The problem is; the combo will not show more than 356 records.  It
will show the entire dataset if it's less than 356 records, but if the
dataset is longer then it just stops at 356.

Is this a built-in feature of Excel?  Is there a switch or property to
look at which tells a combo how many values to hold?  Any help is
greatly appreciated.

Replies