Excel Named Ranges limited to 255 characters

If your source is Excel and you use named ranges, you can’t have a column with more that 255 characters. If you are just referencing the Excel sheet and not a named range, it is not problem.