Excel 5 could handle a maximum of 16,000. Excel 97 went up to 65,000 records. In practice, the only limit now to the number of records a pivot table can handle is the physical memory of your PC, so ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

Excel 5 could handle a maximum of 16,000. Excel 97 went up to 65,000 records but can handle more if you first load the data into an Access database. The new Excel 2007 can handle a million. So pivot ...