| 47296 |
2002-05-05 23:33:00 |
Basically, you can't add more columns than IV to a single worksheet. The maximum size of each worksheet in Excel 2000 is 65536 rows and 256 (i.e. up to IV) columns. You might work around this, which is an inherent limitation, in several ways, e.g. (1)transpose rows and columns with the data you are using (only helpful if you don't use more than 256 rows), or (2)flow your data over into the second or later worksheets of an Excel workbook, or (3) use some other application (e.g.MS Access) that keeps the data in computer memory instead of storing it on a worksheet - you can then use Excel to do any calculations or analysis on subsets of the data without much problem.
I don't think trying to use another spreadsheet such as 123 or Quattro would provide much if any gain. |
Guest (0) |