File Size and Compression

one3nine0

Board Regular
Joined
Jul 21, 2014
Messages
127
I have two tables in Powerpivot 2010, Invoices and a Date Table. The invoices table is only 450,000ish rows

In Excel I have the data in a pivot table filtered by date, product, and order type

The table itself shows Sales Person, Sales Person ID, and Number of units sold.

When I save the file, the file size is 29mb. That seems excessive. At my prior job i had millions of rows in powerpivot 2016 that were only 5-10 mb in size.

Is there less compression power in the 2010 version? Is there a way to compress the file size even more?
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

pvr928

Well-known Member
Joined
Oct 21, 2002
Messages
790
Hi one3nine0

Not sure about compression differences between Powerpivot 2010 and 2016, but have you tried saving the file as binary (.xlsb)? Compared to an .xlsx file, in my experience with large files a .xlsb file is around 40% the size of a .xlsx file.

Cheers

pvr928
 

one3nine0

Board Regular
Joined
Jul 21, 2014
Messages
127
Thanks pvr. Unfortunately it only shrunk the file size by 0.1mb

I wonder if its something to do with my data rather than excel or powerpivot...
 

one3nine0

Board Regular
Joined
Jul 21, 2014
Messages
127
I've read a few and although they talk about the compressibility of data in excel, not a lot I've seen show how to shrink a file with less than 1 million rows.

I also have 0 calculated columns and 0 measures, which is why I don't understand why my file size is so large.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,259
Messages
5,600,575
Members
414,390
Latest member
plimbu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top