geek tip – reduce excel file sizes

I’ve been working with an expenses spreadsheet for a little while, and was rather alarmed at how big the file was getting. There are 7 columns and 56 rows on one workbook, and a 14×10 pivot table on a second workbook. With this small amount of data, the file was reaching 2Mb, which totally didn’t make sense.

The savvy readers will have realized that using a pivot table is the cause – I found a top tip which suggested I do the following:

Right click on the pivot table, and choose the PivotTable Wizard.
Click Options…
Clear the Save data with table layout
Click OK, then Finish
Save the file

Now my file is a much more reasonable 25K.

Leave a Reply