Another reason for large file size is having many unused or hidden worksheets in your Workbook. Each Excel Worksheet has it’s own share of metadata, more importantly, however, you may be keeping sheets with similar datasets, copies or unnecessary Pivot Tables that also take up a lot of space.
How to find out why an excel file is so big?
The fastest method of checking which worksheet causes the workbook to be very big is with Professor Excel Tools. Check the file size of each worksheet with Professor Excel Tools. The overview lists all worksheets with their respective file sizes. Open the “Reduce File” feature on the Professor Excel ribbon.
Remove Hidden / Unused Worksheets Another reason for large file size is having many unused or hidden worksheets in your Workbook. Each Excel Worksheet has it’s own share of metadata, more importantly, however, you may be keeping sheets with similar datasets, copies or unnecessary Pivot Tables that also take up a lot of space.
How do I reduce the size of my Excel file?
Remove “blank space” in your sheets This is definitely the most common source of large Excel file sizes, and fortunately one of the easiest to fix. Excel has a “used range” for every sheet in your workbook. The larger this is, the bigger the file size becomes.
One way to think about this is in effect the XSLX file format will always be larger than the XLSB. To save a file in binary format go to FILEclick on Save Asand select Excel Binary Workbook (*.xlsb) as shown below. Remove Used Cell Range A troublesome thing that can increase your Excel file size is Used Range. Imagine the worksheet below.
Why does inserting an image to an Excel workbook increase file size?
Inserting an image to an Excel workbook increases the file size by the stored size of the image. This is true, even if you crop and resize the image in Excel. That’s because Excel stores the original image. Test results: The file size of a 9 KB Excel workbook with one empty sheet increased to 170 KB when I Inserted a 159 KB image.
Is bigger always better when it comes to excel?
Bigger is not always better. This is certainly true for Excel files. Large workbooks take more time to open and calculate, occupy more storage space, consume more real-time resources, and are more prone to crashing and corruption.