I dont really want to defend Excel, but "Sorting can be limited to one column" is true if the data is not contiguous but excel 2003 onwards gives a warning
- 256 wide is true until Excel 2007. 2007 can access 16000 columns and 1048576 rows. SQL and XML data access allows this to be broken form Excel 2003 onwards
Slashdot Mirror
I dont really want to defend Excel, but "Sorting can be limited to one column" is true if the data is not contiguous but excel 2003 onwards gives a warning - 256 wide is true until Excel 2007. 2007 can access 16000 columns and 1048576 rows. SQL and XML data access allows this to be broken form Excel 2003 onwards