Listed below are some strategies to reduce the scale of an Excel file on Home windows 11/10. Loads of customers have reported experiencing points due to the massive measurement of their Excel workbook. Whereas loading the file, Excel retains lagging or freezing. Enormous file measurement additionally creates issue in sharing the file with others. Now, a number of components can improve the scale of your Excel file. Allow us to discover out these causes.
Why is my Excel file measurement so giant?
One of the primary causes is high-quality photos added to your sheet. Other than that, the pivot cache that’s auto-generated while you add a pivot desk is another excuse behind large-sized Excel information. Different causes for a similar embody extra formatting, an excessive amount of information, embedded objects, and too many worksheets added in a single workbook.
How to reduce the scale of an Excel file?
If the scale of your Excel workbook is just too giant, you should utilize the beneath suggestions and tips to reduce the scale of the Excel file:
- Save your spreadsheet as Excel Binary Workbook.
- Take away pointless worksheets, information, and unused formulation.
- Compress added picture information.
- Don’t retailer the pivot cache together with your Excel file.
- Take away formatting out of your workbook.
- Delete Watch.
- Compress the Excel file utilizing a devoted device.
1] Save your spreadsheet as Excel Binary Workbook
The primary tip that we wish to share to reduce the scale of your Excel file is to save the workbook in Excel Binary Workbook (XLSB) format as a substitute of XLS or XLSX format. This format saves the workbook in a a lot lesser measurement as a result of it saves information in binary format than XML-based format.
Do word that XLS and XLSX codecs are extra broadly used codecs and work with most third-party spreadsheet packages. Nevertheless, the binary format is okay if you’re utilizing the file solely with Microsoft Excel or different software program that assist the XSLB format.
To save lots of your spreadsheet as Excel Binary Workbook, observe the beneath steps:
- First, open the supply Excel file and click on on the File > Choices > Save possibility.
- Now, set the output format to Excel Binary Workbook (.xlsb) and press the Save button.
2] Take away pointless worksheets, information, and unused formulation
It’s also possible to strive deleting pointless worksheets with no related or vital information out of your workbook. Proper-click on the sheet tab from the underside and select the Delete possibility. In addition to that, you can even clear undesirable information and formulation to reduce the scale of your Excel file.
3] Compress added picture information
Need to additional reduce the scale of your Excel file? Nicely, strive compressing the picture information added to your spreadsheet. Pictures with greater decision improve the file measurement of the Excel workbook. So, reduce the scale of embedded photos and it’ll mechanically reduce the scale of the Excel file.
Right here’s how to try this:
- First, choose a picture in your Excel file and go to the Image tab.
- Now, click on on the Compress Footage button underneath the Modify group.
- Subsequent, tick the Apply solely to this image (choose in accordance to your requirement) and Delete cropped areas of footage checkboxes.
- After that, click on on the Use default decision possibility underneath Decision.
- Lastly, press the OK button to compress all of your photos.
Learn: Excel can’t open two workbooks with identical title at identical time.
4] Don’t retailer the pivot cache together with your Excel file
It’s also possible to take away the pivot cache out of your workbook to reduce the Excel file measurement. Once you create a pivot desk in your workbook, Excel mechanically creates a Pivot Cache that mainly shops a reproduction of the information supply. Whereas it’s useful throughout the course of, it will increase the file measurement. So, you possibly can delete the pivot cache to get the file measurement of your Excel workbook decreased.
To do this, click on on a cell in your pivot desk after which go to the PivotTable Analyze tab. Now, underneath the PivotTable group, select Choices and transfer to the Knowledge tab within the appeared dialog window. Subsequent, uncheck the choices referred to as Save supply information with file and Refresh information when opening the file.
Want extra suggestions to reduce the file measurement of an Excel workbook? Transfer on to the following tip.
See: How to take away Metadata from Excel sheet?
5] Take away formatting out of your workbook
If attainable, you possibly can take away formatting out of your spreadsheet to reduce the scale of an Excel file. Formatting is beneficial to make your workbook extra complete and informational. Nevertheless, it additionally will increase file measurement considerably. So, if in case you have the choice to delete all of the formatting, try this, and it’ll mechanically lower the file measurement of a bigger Excel workbook.
To do this, you possibly can go to the House tab and click on on the Clear > Clear Codecs possibility underneath the Enhancing group. This can take away formatting from chosen cells.
Learn: Batch Compress PDF information utilizing free software program and on-line instruments.
6] Delete Watch
Excel supplies a Watch Window utilizing which you’ll be able to simply examine, audit, or affirm system calculations and ends in a big workbook with a number of worksheets. Nevertheless, it might probably improve your file measurement. So, if you find yourself accomplished with watches, you possibly can take away them.
To delete a watch in Excel, go to the Formulation tab and click on on the Watch Window possibility. Now, choose added watches and press the Delete Watch button.
7] Compress the Excel file utilizing a devoted device
If it appears tiring to manually reduce the scale of an Excel file, we advocate utilizing a third-party device. There are lots of on-line instruments and desktop functions that allow you to reduce the scale of differing kinds of information together with Excel information. In case you are searching for a free one, we might advocate utilizing ClipCompress. It’s a good on-line device utilizing which you’ll be able to lower the scale of XLS and XLSX information.
I hope this publish helps you reduce the scale of Excel information.
What software program reduces Excel file measurement?
In order for you to reduce the scale of an Excel file offline, you should utilize a desktop utility. There are some file compression software program that additionally allow you to lower Excel file measurement. To call some, you should utilize NXPowerLite or Excel File Size Reduce Software program by Sobolsoft. These are paid software program with a trial model. In order for you a free device to reduce Excel file measurement, use free on-line instruments like WeCompress or ClipCompress.
Now learn: How to compress and reduce the scale of a Phrase doc?
