Home Dashboard Directory Help

Powerpivot drillthrough limited to 1000 rows in Excel 2013 by Gavin Campbell



Sign in
to vote
Type: Bug
ID: 780558
Opened: 3/4/2013 2:02:52 AM
Access Restriction: Public
User(s) can reproduce this bug



In excel 2010, we could change the maximum number of rows displayed in powerpivot drillthrough in the connection properties.

This appears not to be possible in Excel 2013.
Sign in to post a comment.
Posted by drewskyjones on 2/19/2014 at 11:47 AM
Demoing this to a fortune 100 client with Excel 2013 in a competitive situation today. This is not going to go over well: "the 3 choices are: only 1000 rows, edit the xlsx file with 7-zip or go back to 2010." Client will probably not be very impressed and may go with a competitive technology. Please get this fixed!
Posted by warCHE on 5/28/2013 at 1:47 PM
Is there any update on when / if this will get corrected so it's not greyed out in 2013? The workaround of using 2010 is not viable for some of us that started new projects with 2013 from scratch.
Sign in to post a workaround.
Posted by Kwenix on 6/14/2013 at 2:50 AM
take copy of your xlsx file
-- from here you're on your own..
rename xlsx to zip file
open zip file using 7z
locate connections.xml file in 'xl' folder
hit F4 in 7z to edit file
locate rowDrillCount="1000" and change to desired value
upon saving 7z will update file into the zip file
rename zip to xlsx

it works (for me) with 7z (not with file explorer zip extraction) and avoids to return to Excel 2010
If it doesn't work, see step 1 of the procedure for a backup
Posted by Gavin Campbell on 3/5/2013 at 7:43 AM
Using the 2010 version of the workbook and Excel 2010, change the max rows returned property to 1 million. Then open the workbook with Excel 2013.

As before, the properties dialog is disabled, but the setting of 1 million rows persists.
File Name Submitted By Submitted On File Size  
Fruits2010a.xlsx 3/5/2013 104 KB
Fruits2013a.xlsx 3/5/2013 105 KB