Artikelen

Re-compressing Excel PowerPivot workbooks for an even smaller filesize

Excel

Re-compressing Excel PowerPivot workbooks for an even smaller filesize

Today, I needed to send an Excel-file to a customer, but it was too large according to his mailserver. Of course, there are several solutions to that, but uploading the file to MegaUpload or RapidShare wasn't exactly what the customer had in mind :).

But when you keep in mind that every Office 2007+ file is basically a compressed folder (zip), you can compress the contents of any workbook dramatically. Here's one example: an Excel file containing the AdventureWorks 2012 relational model is around 44,7 MB.

AW filesize before

Extracting this zip in a folder gives me the following list:

Folder contents

Then, I re-zip these files with a higher compression rate (for example using 7-zip on the 'Ultra' mode) and rename the resulting file to '.xlsx':

after rezip

The result is a workbook dramatically reduced in filesize, but the contents are still the same (plus, it can still be opened with Excel).