software

Menu Item Data -gt; Validation has a limit of only 47 Values. why can't it take
more.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

Try putting your list on a different worksheet, name that range and use that
range for the list.

Debra Dalgleish has some notes at:
www.contextures.com/xlDataVal01.html

There's a limit on how much you can type into that dialog.

Keryun wrote:
gt;
gt; Menu Item Data -gt; Validation has a limit of only 47 Values. why can't it take
gt; more.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions

--

Dave Peterson

I have done the same, though the range mentioned is large. it takes only
first 47 values in the range.

quot;Dave Petersonquot; wrote:

gt; Try putting your list on a different worksheet, name that range and use that
gt; range for the list.
gt;
gt; Debra Dalgleish has some notes at:
gt; www.contextures.com/xlDataVal01.html
gt;
gt; There's a limit on how much you can type into that dialog.
gt;
gt; Keryun wrote:
gt; gt;
gt; gt; Menu Item Data -gt; Validation has a limit of only 47 Values. why can't it take
gt; gt; more.
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...et.f unctions
gt;
gt; --
gt;
gt; Dave Peterson
gt;

That's odd. I've never had any trouble getting lots more than 47 values.

Are you sure you used the name in that data|validation dialog?

Keryun wrote:
gt;
gt; I have done the same, though the range mentioned is large. it takes only
gt; first 47 values in the range.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Try putting your list on a different worksheet, name that range and use that
gt; gt; range for the list.
gt; gt;
gt; gt; Debra Dalgleish has some notes at:
gt; gt; www.contextures.com/xlDataVal01.html
gt; gt;
gt; gt; There's a limit on how much you can type into that dialog.
gt; gt;
gt; gt; Keryun wrote:
gt; gt; gt;
gt; gt; gt; Menu Item Data -gt; Validation has a limit of only 47 Values. why can't it take
gt; gt; gt; more.
gt; gt; gt;
gt; gt; gt; ----------------
gt; gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; gt; click quot;I Agreequot; in the message pane.
gt; gt; gt;
gt; gt; gt; www.microsoft.com/office/comm...et.f unctions
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Dave, after you were confident i tried again, it worked. sorry for the
confusion.

quot;Dave Petersonquot; wrote:

gt; That's odd. I've never had any trouble getting lots more than 47 values.
gt;
gt; Are you sure you used the name in that data|validation dialog?
gt;
gt; Keryun wrote:
gt; gt;
gt; gt; I have done the same, though the range mentioned is large. it takes only
gt; gt; first 47 values in the range.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Try putting your list on a different worksheet, name that range and use that
gt; gt; gt; range for the list.
gt; gt; gt;
gt; gt; gt; Debra Dalgleish has some notes at:
gt; gt; gt; www.contextures.com/xlDataVal01.html
gt; gt; gt;
gt; gt; gt; There's a limit on how much you can type into that dialog.
gt; gt; gt;
gt; gt; gt; Keryun wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Menu Item Data -gt; Validation has a limit of only 47 Values. why can't it take
gt; gt; gt; gt; more.
gt; gt; gt; gt;
gt; gt; gt; gt; ----------------
gt; gt; gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; gt; gt; click quot;I Agreequot; in the message pane.
gt; gt; gt; gt;
gt; gt; gt; gt; www.microsoft.com/office/comm...et.f unctions
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;