ExcelBanter - Pivot Table Error Message - "too many records" Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Error Message - "too many records" Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/209195-pivot-table-error-message-too-many-records-excel-2007-a.html)

MAK

Pivot Table Error Message - "too many records" Excel 2007

I am creating a pivot table using approx 3,000 line data worksheet and when
generating a formula an error message comes up - "There are too many records
to complete the operation". WHen I have read about 2007 there should be no
reason for this message!

Using Excel 2007

All times are GMT +1. The time now is 11:12 PM.