Excel: Column IW is not working
Question by PlasmaTV | 2023-12-23 at 15:05
When trying to create an XLS file, I get a strange error. For some reason I cannot enter any data into the column IW. All other columns before (up to column IV) work as usual without any problems.
Can someone help me? I would like to use more columns of my Excel table. There are also many more columns shown in my program.
Related Topics
XLS and XLSX: Maximum Number of Columns and Rows
Info | 2 Comments
MySQL: Add new Column to a Table
Tutorial | 0 Comments
MySQL: Write current Date or Time into Column
Tutorial | 0 Comments
Quicksort: Sort two Columns
Question | 1 Answer
MIME Types of Microsoft Office File Formats
Info | 0 Comments
Excel: How to enter Line Break within Cell
Question | 1 Answer
Excel: Save Spreadsheet without Macros
Question | 1 Answer
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
The now-deprecated XLS format has a limit of 65,536 rows and 256 columns. The 256th column is column IV and therefore the limit for this spreadsheet format. Therefore, you cannot insert any values starting from the IW column.
I recommend you to use the newer and current XLSX format. You can enter much larger amounts of data in this, the limit here is 1,048,576 rows and 16,384 columns, which corresponds to the XFD column as the last column. This format change would give you space for your data again.
You can find out more about this topic in the article about the maximum number of columns and rows of XLS and XLSX files. There, you can also see how the formats have changed over time and in which years and with which versions of Excel the respective formats were introduced.
2023-12-23 at 23:12