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 Management Reporting page collects together all AccountingWEB’s resources on Reporting. These range from tutorials on Excel pivot tables, MS Access, and Sage Line 50, through to discussions about ...