Cause
Excel 2007 format workbooks (.xlsx, .xlsm, .xlsb) have 16,384 columns
Excel 97-2003 format workbooks (.xls) have only 256 columns (IV is the last)
Solution
If the file extension is .xls (version Excel 97-2003) save the file to .xlsx (version 2007).
Then you can now insert column.
Excel 2007 format workbooks (.xlsx, .xlsm, .xlsb) have 16,384 columns
Excel 97-2003 format workbooks (.xls) have only 256 columns (IV is the last)
Solution
If the file extension is .xls (version Excel 97-2003) save the file to .xlsx (version 2007).
Then you can now insert column.
0 comments:
Post a Comment