Excel 2013; I want more details!

In Excel 2010 it was possible to increase the number of rows Excel would return after initiating a drillthrough. In Excel 2013 this option seems to be disabled

Excel 2013 connection propperty windowOn the computer I worked on the dutch version was installed đŸ™‚Â 

I work with many Excel pro’s, so you can imagine the furious reactions I got. It seems other people have found this “issue” too and posted about it on connect.

The good news? There is a workaround (posted by “Kwenix” on the connect item mentioned above) and yes it works!

To safe you time I repeated the described steps below:

  1. Make a backup of your Excel file
  2. Rename xlsx to zip file
  3. Open zip file using 7z
  4. Locate connections.xml file in ‘xl’ folder
  5. Hit F4 in 7z to edit file
  6. Locate rowDrillCount=”1000″ and change to desired value
    upon saving 7z will update file into the zip file
    rename zip to xlsx

And thats it! I urge everyone to vote on this connect item!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s