Powerpivot drillthrough limited to 1000 rows in Excel 2013
This is for excel 2013 only.
Take copy of your xlsx file
-- from here you're on your own..
Rename xlsx to zip file.
Copy Zip in to another folder.
Open zip file using 7z. (http://sourceforge.net/projects/sevenzip/files/7-Zip/9.20/7z920-x64.msi/download?use_mirror=softlayer-dal).
Right click on th zip folder, select 7z-->Extract here.
Delete your zip file (Source).
You will get all file.
Open XL folder.
Open connections.xml file
locate rowDrillCount="1000" and change to desired value.
Save the file.
Go back to your root folder.
Zip all files (Whatever the files we got when we extract..) using 7z
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.
This is for excel 2013 only.
Take copy of your xlsx file
-- from here you're on your own..
Rename xlsx to zip file.
Copy Zip in to another folder.
Open zip file using 7z. (http://sourceforge.net/projects/sevenzip/files/7-Zip/9.20/7z920-x64.msi/download?use_mirror=softlayer-dal).
Right click on th zip folder, select 7z-->Extract here.
Delete your zip file (Source).
You will get all file.
Open XL folder.
Open connections.xml file
locate rowDrillCount="1000" and change to desired value.
Save the file.
Go back to your root folder.
Zip all files (Whatever the files we got when we extract..) using 7z
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.
