Forum Discussion
Data Validation
I created a drop down using Data Validation and need to know if there is a limit to the list items? IF so, is ther a work around? I need to have
Data review list limited?
As of Excel 2007, this limit has been increased and is now 32,767 characters per cell.
*Theoretically, if you also save old files before Excel 2007 with "Save As" under a new file name and select "Excel workbook (* .xlsx)" as the format, this should also expand to 32,767 .
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
As of Excel 2007, this limit has been increased and is now 32,767 characters per cell.
*Theoretically, if you also save old files before Excel 2007 with "Save As" under a new file name and select "Excel workbook (* .xlsx)" as the format, this should also expand to 32,767 .
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.