Custom Lists Limitation Excel 2007

I had the same problem when manually entering or copy/pasting all the values but if I put the list in an Excel worksheet, I was able to import the entire list by selecting that cell range using the Excel Options in the Microsoft Office Button.  Here is a link (scroll down to "Create a Custom List from a Cell Range" under the "Create a Custom List" heading. 

http://office.microsoft.com/en-us/excel-help/create-or-delete-a-custom-list-for-sorting-and-filling-data-HA010222142.aspx

EXCERPT from that webpage:

Create a custom list from a cell range    

1. In a range of cells, enter the values that you want to sort or fill by, in the order that you want them, from top to bottom. For example:

1. Select the range that you just typed. In the preceding example , you would select cells A1:A3.
2. Click the Microsoft Office Button , click Excel Options, click the Popular category, and then under Top options for working with Excel, click Edit Custom Lists.
3. In the Custom Lists dialog box, verify that the cell reference of the list of items that you selected is displayed in the Import list from cells box, and then click Import.

The items in the list that you selected are added to the Custom Lists box.

1. Click OK twice.

It's back (in 2007; I'm still not experiencing the limitation in 2003).  The long lists that I was able to get in are still there and working properly, but I tried to enter another and got the message, "The maximum length for a custom list has been exceeded.  Only the first 255 characters will be saved."  So strange.

I typed the following list into cells in a workbook, highlighted the cells, clicked Tools, Options, Custom Lists (Excel 2003) or Excel Options, Edit Custom Lists (Excel 2007), clicked Import, then Add.  In 2003 it worked fine, in 2007 I got a message that there was a 255 character limitation. The list was added but cut off in the middle of Test List Earth.

Note, this is the third time I have tried this, previously with real lists.  Oddly, as I went back to do this again so I could copy the actual message it worked.  The full list is entered.  I then tried it with my original lists and they work too.  Problem magically solved.  Interesting that you found a limitation in all versions, and now I'm not limited in either.  Thanks for trying to answer.  I'd love to know what's going on here if anyone knows. 

Give us more info on what you think as custom list and where are you entering it coz i tested it in excel 2003/2007/2010 and all the three products, it is limited to 255......please give us more details to help you

BLACK BARRON

P.S : Please post back with the status of the issue. If this post was helpful to you, please vote for my post If this post has helped you resolve your issue, please mark my post as answered.