In the regular excel part of your workbook, go to the Data tab. There you will see a section called Connections. In the Connections part you will see Properties. Go into Properties and towards the bottom of the Usage tab you will see OLAP Drill Through. This is where you can adjust the number of records you get when you double click a value in your pivot.