Pivot Table - How to get all data to display when using "SHOW DETAIL"

Hello. When in Pivot table, I have 80K distinct data. How do I display and return all data when I select cell and do the SHOW DETAIL function? When I do, I just get 1000 rows of data in a separate worksheet and not the 80K. I get this output 'Data returned for Distinct Count of Name (First 1000 rows)." How do I display ALL rows? Any assistance is much appreciated. Thank you. W

answered at this cross-post:
https://stackoverflow.com/questions...et-all-data-to-display-when-using-show-detail