Pivot Table Cache Limit


When the data used to generate a pivot table on your workbook is present inside the workbook, you can click any value in the pivot table to generate a complete list of the data used for this value on a new worksheet. However, if the data source for the pivot table was an outside file which is no longer linked to, when a value in the pivot table is clicked on you may receive this error message:

This "Not all source records have been copied" error will come up if the source data file had more than 65,536 rows. Excel creates a cache of the pivot table's outside data source (which shows the totals listed in the table itself based on the original complete data source) but only retains the first 65,536 rows of the data source.