Tag Archives: File Size

Pivot Tables and File Size

This is a sneak preview of my upcoming Udemy course on Pivot Tables. This video explains the  relationship between Pivot Tables and File Size. Watch this 6 minutes video and learn from it.

Apply this knowledge to your existing pivots – especially those with large file sizes and see the difference. Make sure you try it out on a copy. Never learn using Live files.

Continue reading Pivot Tables and File Size

Did you know? Pivot Tables can increase the file size!

The problem with large Excel files

Today I was conducting an efficiency optimization session for Risk Management team of a global bank. During the discussion, one of the problems we discussed was large Excel files. Although there are many reasons for large Excel files, one of the reasons is easier to manage and it is largely unknown. It relates to files containing one or more Pivot Tables.

Quick Summary

Pivot Table creates a copy of the source data and saves it in the file. This increases the file size and also slows down the open / close operations. You can ask Excel NOT to save the copy of the data and save on file size. Right click inside pivot, Pivot Table options, Data tab, clear the checkbox Save source data with file. That solves the file size inflation problem.

pivot table increase file size

Read more to understand when to use and when NOT to use this feature.

 

 

Continue reading Did you know? Pivot Tables can increase the file size!

Reduce PowerPoint file size by compressing ALL images in one go

Presentations containing lot of photos or images tend to be very large in size. It makes them unmanageable and often impossible to send by mail.  Yes, you can compress images one by one, but since Powerpoint presentations usually contain lots of images, it would be a tiresome and furstrating job.

But fear not! There is an solution!

You can compress ALL photos / images in ONE step!

Continue reading Reduce PowerPoint file size by compressing ALL images in one go