Selasa, 16 September 2008

How to Increase 2003 to 2007 Worksheet Capacity in MS Excel

2003 to 2007 Increased Worksheet Capacity in MS Excel
Do you regularly work with data sets larger than the capacity of 65,536 rows by 256 columns in Microsoft Office Excel 2003? Microsoft Office Excel 2007 supports up to 1,048,576 rows by 16,384 columns, so you no longer have to use many different worksheets to support your data. You can use the zoom slider at the lower right of the Office Excel 2007 window to zoom out for a bird's-eye view of how much data your worksheet can hold.
To support a bigger grid, Office Excel 2007 uses several other increased limits. For example, the number of rows allowed in a Microsoft PivotTable chart has increased from 64,000 to more than 1 million, and the amount of memory that Excel can use has increased from 1 gigabyte (GB) to the maximum allowed by the Windows operating system. The limit on the number of rows in a column or columns that can be referred to in an array formula has been completely eliminated.

Tidak ada komentar:

Posting Komentar