top of page

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.


 

Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page