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

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 780558 Comments
Status Closed Workarounds
Type Bug Repros 9
Opened 3/4/2013 2:02:52 AM
Access Restriction Public



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.