Longer Custom Lists in Excel 2007

  • Hello - I am trying to create a custom list in Excel 2007 by importing cells A1:A312. Unfortunately the custom list stops at row 102 and rows 103 and beyond are not included.


    Is there a way to create a longer custom list than the 102?


    Thank you for any help!

  • Re: Longer Custom Lists in Excel 2007


    That might be a limitation in 2007 (total characters in list not to exceed 255), according to a thread I just found: http://answers.microsoft.com/e…de-462f-b492-781ed9adf181. I can't test as I don't have 2007.


    Does the number of cumulative characters in your list from topdown exceed 255 chars? If so, is it at about row 102 where the exceeding happens?


    I tested it in my version of 2013 and it is not limited to 255.


    Someone else with 2007 can test perhaps.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Longer Custom Lists in Excel 2007


    Thank you, NBVC. Yes, initially I'd tried to create it using a single cell and that was impossible as it reached the 255 limit about 13 rows in. Importing from the cells allowed me to go down to 102 rows but still stopped there. Curious.

  • Re: Longer Custom Lists in Excel 2007


    What is the cumulative count of characters at Row 101, then 102, and then 103? Maybe you have reached another limit.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Longer Custom Lists in Excel 2007


    At row 101 the cumulative length is 2077, at 102 it is 2099 and at 103 it is 2120. So perhaps 2100 is the limit...

  • Re: Longer Custom Lists in Excel 2007


    It's an odd number, but could be.


    We would need to wait for someone with 2007 to test

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Longer Custom Lists in Excel 2007


    in 2013, i was able to import a cumulative number of chars equal to about 1875 (maybe the commas between are counted in the final list too).

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Longer Custom Lists in Excel 2007


    I have 2007 and like snb my limit is 2000

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!